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)?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create multiple bar charts at the same time? 0
Rows of data, using status columns to sort data to pie chart on another worksheet tab 1
i need to create a pie graph 1
Q:Temporarily Freeze Charts Updates 2
Is it possible to REFRESH the CHART ? 2
Excel Graphing 3
Chart Objects Behaving Badly 4
Excel 2007 graphs/charts automatically populate with new data 1

Back
Top