View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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?

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