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

how do create pie

Forum home » Delegate support and help forum » Microsoft Excel Training and help » How do i create a pie chart?

How do i create a pie chart?

ResolvedVersion 2003

Caroline has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course

How do i create a pie chart?

whats the quickest way?

RE: how do i create a pie chart?

Hi Caroline

How are you today and thankyou for your post

the quickest way of inserting a pie chart is as follows:

highlight the cells for the pie, then press F11 on your keyboard, if you then want this a an object for your sheet, go to the chart menu and click location and choose as object in

then go back to the chart menu and click chart type, pick the pie chart type you want and click OK

You could also go to the insert chart button and click the PIe type then click FINISH

Both should do the trick, but for quick chart insertion remember F11

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.