General discussion

Locked

Excel 2000 and Charts

By layland ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 2000 and Charts

by mbazzell In reply to Excel 2000 and Charts

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!

Collapse -

Excel 2000 and Charts

by layland In reply to Excel 2000 and Charts

Poster rated this answer

Collapse -

Excel 2000 and Charts

by layland In reply to Excel 2000 and Charts

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums