Hello to all,

Anyone know how to chart multiple sheets in the same workbook?

I know to chart a single sheet such as =Sheet1!R1C1:R1C6
but what I want to chart is a single field through multiple sheets and I can't figure out how to do this. such as charting field r1c1 on sheets1:sheets27

Any help is greatly appreciated.

Mythos.

In Source data, you would have to identify each point separately.