pie charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pie charts

Pie charts

resolvedResolved · Low Priority · Version 2003

Jeff has attended:
Word Intermediate course
Excel Intermediate course

Pie charts

how to update pie charts

RE: pie charts

Hi Jeff

Thank you for your question

Pie charts can be updated in a number of ways

To alter the data that the chart is graphing, simply change the figures in the relevant cells. If the new data is in a different range, right click on the chart area of the graph, select "source" and then enter the new range

You can alter the formats of different parts of the chart simply by right clicking on the area, choosing the format command and then changing the colour and other properties

Hope this is useful

Regards

Stephen

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips


Server loaded in 0.08 secs.