ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   multiple series of values graphed with indep. x values -possible? (https://www.excelbanter.com/charts-charting-excel/45823-multiple-series-values-graphed-indep-x-values-possible.html)

Gburg Johnny

multiple series of values graphed with indep. x values -possible?
 
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.

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


Gburg Johnny wrote:

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.



All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com