| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a High-Low-Close chart with multiple series? | Charts and Charting in Excel | |||
| Excel should not automatically extend series or fill values | Excel Discussion (Misc queries) | |||
| Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
| Creating a High-Low-Close chart with multiple series? | Excel Discussion (Misc queries) | |||
| Multiple X-Axis Values | Charts and Charting in Excel | |||
Linear Mode
