Thread: Chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Walley Walley is offline
external usenet poster
 
Posts: 12
Default Chart

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