Two sets of data on one chart

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?

Add the second set of data to the graph, then right click on one of the bars.
Select Chart type then Line and you will end up with the predicted values showing as a line on top of the actual bars

The following site should help: http://peltiertech.com/Excel/Charts/

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

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?