Summing Data Series

I have just created a chart, but rather than show each
data series individually, it has added them together.

Hence the first data series shows the values from Column A
of my Sheet correctly, but the second series shows the
values from column A PLUS the valus from COlumn B,
similarly the third series shows the sum of the values
from Columns A, B and C.

Why is Excel doing this? I am using Excel XP

That is rather strange -- unless, of course, you are creating a stacked
column chart, in which case the behavior is as expected.

If not, how *exactly* did you create the chart? And, what does the
data set contain?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <0c3001c3af7f$8d09c140$a501280a@phx.gbl>,
Gary.ThomsonNOSPAAAAM@PLEEEASEMidlothian.gov.uk says...
> I have just created a chart, but rather than show each
> data series individually, it has added them together.
>
> Hence the first data series shows the values from Column A
> of my Sheet correctly, but the second series shows the
> values from column A PLUS the valus from COlumn B,
> similarly the third series shows the sum of the values
> from Columns A, B and C.
>
> Why is Excel doing this? I am using Excel XP
>

YOu're right, I had a stacked Data Series. THankX.




>-----Original Message-----
>That is rather strange -- unless, of course, you are
creating a stacked
>column chart, in which case the behavior is as expected.
>
>If not, how *exactly* did you create the chart? And,
what does the
>data set contain?
>
>--
>Regards,
>
>Tushar Mehta, MS MVP -- Excel
>www.tushar-mehta.com
>Excel, PowerPoint, and VBA add-ins, tutorials
>Custom MS Office productivity solutions
>
>In article <0c3001c3af7f$8d09c140$a501280a@phx.gbl>,
>Gary.ThomsonNOSPAAAAM@PLEEEASEMidlothian.gov.uk says...
>> I have just created a chart, but rather than show each
>> data series individually, it has added them together.
>>
>> Hence the first data series shows the values from
Column A
>> of my Sheet correctly, but the second series shows the
>> values from column A PLUS the valus from COlumn B,
>> similarly the third series shows the sum of the values
>> from Columns A, B and C.
>>
>> Why is Excel doing this? I am using Excel XP
>>
>.
>