Graphs

[Boenerge]

Hi,
I have created a workbook with several sheets inside.
Each sheet has specific dates, ready for data to be inputted.
As data is inputted then there are graphs along the top.
The problem is when I set up the sheet I set the first one up and then
copied the rest, changing the date. I have now discovered that the graphs
show the first sheets dates and not the dates the on its own page. Also all
the graphs show the data from the first page. Is there a quick way of
readjusting the graphs to report data from the page it sits on? or does it
have to be changed manually?

Also is there a formula I can use for a cell to show data from a specific
cell on page 1?
Thanks in advance,
Jason

 

[ShaneDevenshire]

Hi Boenerge,

Don't copy the sheet by selecting the sheet or range and choosing Copy.
Instead right click the sheet tab and choose the Move or Copy command. Quick
way is to drag the sheet tab while holding down the Ctrl key.

After the fact (if you have already copied a lot of sheets) you can select a
chart and choose Chart, Source Data, select the Data Range box and highlight
the correct range.

Second question - Point and click. - move to the cell where you want the
data to show up from another sheet and type = then click on the sheet tab and
then cell of the sheet where the data is. Press Enter.