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

chart

ResolvedVersion 2007

tessa has attended:
Excel Advanced course

Chart

Take out a pie of the chart in the pivot table in order for it to look nice

RE: chart

Hi Tessa

Thank you for your question.

You can move the chart to its own sheet by left clicking the chart then going to the green Pivot Chart Tools Ribbon and choosing the Design Tab. On the far right of the ribbon is the Move chart button. Click it and choose to move to a new sheet. You can also use the same process to move it back to its original sheet.

Alternatively if you right click your chart you can copy then paste into another sheet or another application like Word or PowerPoint

I hope this helps - let me know if you have any other questions.

Kind regards,
Andrew

Wed 3 Sep 2014: Automatically marked as resolved.

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

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.13 secs.