Add source data to an existing chart?
 

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! :)


--
navychef
------------------------------------------------------------------------
navychef's Profile: http://www.excelforum.com/member.php...o&userid=29457
View this thread: http://www.excelforum.com/showthread...hreadid=495641

Add source data to an existing chart?
 

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" wrote in
message ...

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! :)


--
navychef
------------------------------------------------------------------------
navychef's Profile:
http://www.excelforum.com/member.php...o&userid=29457
View this thread: http://www.excelforum.com/showthread...hreadid=495641

Add source data to an existing chart?
 

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

Merry Christmas!

Bob


--
navychef
------------------------------------------------------------------------
navychef's Profile: http://www.excelforum.com/member.php...o&userid=29457
View this thread: http://www.excelforum.com/showthread...hreadid=495641