I need to have my graph automatically update...

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

Guest

I have a workbook with about 10 different sheets. Each sheet is linked to a
main stats sheet. From there, an average for each stat is calculated. From
the averaged calculation I have created a pie chart.

What I want to do is have the pie chart update everytime I update one of the
10 data pages. Unfortuntately, the program only suggests that I write the new
value in the specific cell that is used in the pie chart, then press "enter."
If I do that, I lose the formula that has it update automatically. Is my
request even possible???!!!!

Any and all suggestions will be greatly appreciated.

Thanks,
Luke
 
Hi

not sure i'm understanding this, you have a pie chart based on a summary
page which is created by formulas from the underlying sheets ... the pie
chart is not based at all on "typed in figures" only calculated one? if
this is the case it should update automatically ... is workbook calculation
set to automatic (tools / options / calculations)?
 
Back
Top