Cells on another sheet in the book

jlaw1981

New Member
Joined
Sep 25, 2006
Messages
1
I would like to create a chart based on a cell from each of the other pages in my book and place it on a new sheet. How do I tell the chart to look at the one cell from each sheet?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

You can set up a data sheet that references each sheet, then use that for
the chart data.

HTH,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,726
Members
410,630
Latest member
JFORTH97
Top