Chart

  • Thread starter Thread starter Walley
  • Start date Start date
W

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
 
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
 
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
 
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
 
Thanks very much for help, I will pull the data together in one range to new
sheet where my chart will be. Thanks
 
Back
Top