Discussion Locked

Excel 2000 and Charts

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a spread sheet with percentages and the perecentages have charts to represent the numbers. I update the spread sheet monthly. Is there away to update the charts automatically when I put in percentages into the spread sheet in Excel?

3 replies

by mbazzell

When you set up your chart, if you right click on it and select format data series. Then click on the Data Labels tab and click on percentages. If you put your labels on like this, anytime you change your data it automatically updates your chart.If you put your labels on with a text box, it WON'T automatically update your chart.

Hope this helps!

This discussion is closed to new replies.