Chart

[Walley]

Hi
I have 3 excel sheets with names October2008, November2008 and December2008.
I want to insert chart in forth sheet and selected data from these three
sheets as shown with this formula

for vertical axis
=October2008!$C$7:$C$28+November2008!$C$6:$C$25+December2008!$C$6:$C$25
for horizontal axis
=October2008!$B$5:$B$28+November2008!$B$7:$B$25+December2008!$B$6:$B$25
but I get formula errors, if there is any possibility to rewrite the above
formula, or any other formula whicch can the chart show my data.
thanks

 

[Shane Devenshire]

Hi,

You don't really want to add the values in those ranges, you want to display
the contents so use

=October2008!$C$7:$C$28,November2008!$C$6:$C$25,December2008!$C$6:$C$25

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

 

[Walley]

thanks, yes I want to display these data in the chart, I have test
=October2008!$C$7:$C$28,November2008!$C$6:$C$25,December2008!$C$6:$C$25, but
it does not work, and I have test also
=October2008!$C$7:$C$28;November2008!$C$6:$C$25;December2008!$C$6:$C$25 but
it does not work also and I got error

 

[Shane Devenshire]

Hi,

That will teach me not to test!, If you want to plot from separate sheets:
1. the X-axis range must contain the same labels, so you only plot that once.
And although you want to enter the formula like we tried, you should instead
us the Series tab of the wizard and click Add, click in the Values box and
highlight one of the data range. then click Add again and in the Values box
highlight the other range, then click in the Category X-axis box and
highlight the x-axis items from one or the other sheet. This will give you
two series.

If on the other hand you are trying to put the series together as one long
series certainly the easiest way is to pull the data together in one range,
either by copy and paste or using formula, and then plot that range.

Cheers,
Shane Devenshire

 

[Walley]

Thanks very much for help, I will pull the data together in one range to new
sheet where my chart will be. Thanks