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?

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/
_______


"navychef" <[email protected]> wrote in
message news:[email protected]...
>
> 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