If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel 2007 Charts don't update
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
excel 2007 Charts don't update
Bob
Appreciate the quick response. However this is not quite the problem. The data may totally change but the chart remains the same "Bob Umlas, Excel MVP" wrote: 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 |
#4
|
|||
|
|||
excel 2007 Charts don't update
Learned that if I filter the data and then change the filter back to "All"
then Charts change. Just have to be sure I pick something that is always there, so I put a dummy date at the beginning of the data and choose it via a macro and then choose all. Voila it's fixed "Steve" wrote: Bob Appreciate the quick response. However this is not quite the problem. The data may totally change but the chart remains the same "Bob Umlas, Excel MVP" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|