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+De cember2008!$C$6:$C$25
for horizontal axis
=October2008!$B$5:$B$28+November2008!$B$7:$B$25+De cember2008!$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,De cember2008!$C$6:$C$25

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

"Walley" wrote:

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+De cember2008!$C$6:$C$25
for horizontal axis
=October2008!$B$5:$B$28+November2008!$B$7:$B$25+De cember2008!$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

If you have data in more than one sheet and you want to include it in one
series in a chart, the easiest way is to use a spreadsheet to pull the data
together into one range in the spreadsheet, then plot from there.
--
David Biddulph

"Walley" wrote in message
...
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+De cember2008!$C$6:$C$25
for horizontal axis
=October2008!$B$5:$B$28+November2008!$B$7:$B$25+De cember2008!$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

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

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,De cember2008!$C$6:$C$25

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

"Walley" wrote:

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+De cember2008!$C$6:$C$25
for horizontal axis
=October2008!$B$5:$B$28+November2008!$B$7:$B$25+De cember2008!$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,

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" wrote:

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

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,De cember2008!$C$6:$C$25

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

"Walley" wrote:

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+De cember2008!$C$6:$C$25
for horizontal axis
=October2008!$B$5:$B$28+November2008!$B$7:$B$25+De cember2008!$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

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


"Shane Devenshire" wrote:

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" wrote:

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

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,De cember2008!$C$6:$C$25

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

"Walley" wrote:

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+De cember2008!$C$6:$C$25
for horizontal axis
=October2008!$B$5:$B$28+November2008!$B$7:$B$25+De cember2008!$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