updating pie charts

[Lilsis7]

I have a spreadsheet with our sales per reps on it, and at the bottom is a
pie chart. I have used this for 3 years now. Suddenly, the pie chart does
not update when I enter in new sales, therefore my work is no longer
accurate. How do you get the pie chart to update automatically every time
without having to recreate it? I never had to worry about the accuracy
before!

[SSG QuarterMaster]

check your source data range for the chart

"Lilsis7" wrote:

> I have a spreadsheet with our sales per reps on it, and at the bottom is a
> pie chart. I have used this for 3 years now. Suddenly, the pie chart does
> not update when I enter in new sales, therefore my work is no longer
> accurate. How do you get the pie chart to update automatically every time
> without having to recreate it? I never had to worry about the accuracy
> before!

[Lilsis7]

Yes, have checked data source, it is accurate. I shouldn't have to do
anything to refresh or update the pie chart. I have looked into this and it
should be automatic. The only way I can make sure it updates is to remove
the data labels before I update the dollar amounts for each rep. After that,
I return the data labels to the chart - I should not have to do anyting~ I
thought maybe my settings were wrong under tools/options, but I don't see
anything there, either! It is really frustrating

"SSG QuarterMaster" wrote:

> check your source data range for the chart
>
> "Lilsis7" wrote:
>
> > I have a spreadsheet with our sales per reps on it, and at the bottom is a
> > pie chart. I have used this for 3 years now. Suddenly, the pie chart does
> > not update when I enter in new sales, therefore my work is no longer
> > accurate. How do you get the pie chart to update automatically every time
> > without having to recreate it? I never had to worry about the accuracy
> > before!