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