creating charts with XY

  • Thread starter Thread starter Willy
  • Start date Start date
W

Willy

Hi, I thought I was well versed with Excel and charting, but...
How can I create a chart with several lines, where I indicate the X and
Y coordinates?
For example, a chart with X = 100, Y = 100, and another line where X =
170, Y = 120?
Can this be done in either Excel directly, or VBA?
Thanks in advance,
Willy
 
Hi, I thought I was well versed with Excel and charting, but...
How can I create a chart with several lines, where I indicate the X and
Y coordinates?
For example, a chart with X = 100, Y = 100, and another line where X =
170, Y = 120?
Can this be done in either Excel directly, or VBA?
Thanks in advance,
Willy
Click to expand...
A line needs two points (at least). So, you have to specify something
more than "another line were x=170,y=120."

In general, you can have any number of lines in a chart. The easiest
way to do that is put all the data in adjacent columns, select any cell
in that range and click the chart wizard button.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top