excel training in uk - pivot chart displaying
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

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 training in uk - Pivot Chart - displaying the grand total column

resolvedResolved · Low Priority · Version Standard

replyReply Fri 10 Aug 2007, 13:41Delegate Zohra said...

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

For upcoming training course dates see: Pricing & availability

replyReply Mon 13 Aug 2007, 12:00Trainer Richard said...

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 articles

· How To Use Excel To Create Large SQL Insert Statements
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· How To Embed Fonts In Excel
· Going Against The Grain With Multiple Radio Buttons In Excel
· Take the Anxiety out of Domestic Finances with Microsoft Excel

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy