multiple series of values graphed with indep. x values -possible?

G

Gburg Johnny

I'm trying to make a line graph with three different sets/series of data
points (y values are dollars, x axis is specific dates). I can only figure
out how to make it so that there is only one series of x-values, with three
y-values associated with each x-value. Is it possible to have three lines on
the same graph, but not necessarily common x-values in the data points. Let
me know if you can help! Thanks.
 
J

Jon Peltier

That's a shortcoming with line charts. In fact, the name "line chart" is
probably misleading you. Use an XY chart, and format the series to have
lines and markers.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top