Add source data to an existing chart?

[navychef]

Hello!

I am building a chart to display, by date, data in columns G
(breakfast), D (lunch), and J (dinner).

I can get the chart with dates along one axis and column G along the
other, but how do I add the data from D and J to create a stacked bar,
to show for each day how each of the three columns compare and give a
daily total for all three meals?

THANKS TO EVERYONE FOR YOUR HELP!

 

[Jon Peltier]

Go to Source Data on the Chart menu, click on the Series tab. Click Add,
then populate the Values and Name box as appropriate. To select a range,
click in the input box, then select the range under the dialog box.

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

 

[navychef]

Thank you much, Jon - Sometimes the simpler things escape me, but thi
forum is becoming an immense help.

Merry Christmas!

Bo