excel training in uk - pivot chart displaying

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

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

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

resolvedResolved · Low Priority · Version 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

 

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:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips


Server loaded in 0.08 secs.