Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Go to the Chart menu, choose Source Data, select the Series tab, and click the Add
button. Select the cell range for the second series' Y values. If it's a line or column chart, that's all you need. If it's a Scatter chart, also select the cells for the X range. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ AYakos wrote: I have made a bar chart containing actual dollars on the y axis and months on the x axis. I would like to add a line to the same chart which would represent estimated dollars on the y and months on the x to compare the actual to the estimate on the same chart. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |