Charting through Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to create a graph in sheet one that looks at a range
through sheet 2 to sheet 6.

For example the graph range would read "sheet2!a5:sheet6!a5", however each
time I do this excel tells me it is illegal. I can do it in 123 but not
excel. Anyone know how to do this?
 
Back
Top