Add source data to an existing chart?

  • Thread starter Thread starter navychef
  • Start date Start date
N

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? :confused:

THANKS TO EVERYONE FOR YOUR HELP! :)
 
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/
_______
 
Thank you much, Jon - Sometimes the simpler things escape me, but thi
forum is becoming an immense help.

Merry Christmas!

Bo
 
Back
Top