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

excel training in uk - pivot chart displaying

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in uk - Pivot Chart - displaying the grand total column

excel training in uk - Pivot Chart - displaying the grand total column

ResolvedVersion Standard

Zohra has attended:
Excel Advanced course
Excel Intermediate course
Excel VBA Intro Intermediate course

Pivot Chart - displaying the grand total column

Hello,

How do I get a pivot chart to display the grand total column of the table?

Thanks,

Zohra

RE: Pivot Chart - displaying the grand total column

Hi Zohra

Simply right click on the pivot table, choose TABLE OPTIONS and in the top left you will see some tick boxes relating to grand totals.

Regards

Richard

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