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


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

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?

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

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