View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default excel 2007 Charts don't update

If you're adding data below the range pointed to by the chart, then the chart
won't update. If you put the source data in an Excel Table, then the chart
will update. Otherwise, you're going to have to click on the chart & drag the
range indicators down to increase the # of rows used.

"Steve" wrote:

As new data is input the chart remains the same and doesn't reflect new data.
The data values and number of entries can be completely different. I think
there is a setting somewhere to automate the chart update but I can't find it.
Thanks
Steve