Thread: creating charts with XY

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

Im sorry but I dont understand what you want?

"Willy" wrote:

> 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
>
>

In article <1126118026.683717.270110@g14g2000cwa.googlegroups.com>,
w8lifta2000@yahoo.com says...
> 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
>
>
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