Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating pie charts
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating pie charts
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating pie charts
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not updating when data feeding chart is changed | Charts and Charting in Excel | |||
Updating charts when data source is in a different file | Charts and Charting in Excel | |||
Automatic Updating Charts | Charts and Charting in Excel | |||
updating charts automatically | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel |