Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Graphs from pivot tables

	98.1 % recommend us
	More live stats...

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

Training information:

Graphs from pivot tables

Resolved · Urgent Priority · Version 2003

Reply Thu 19 Aug 2010, 11:44Delegate sumayyah said...

sumayyah has attended:
Excel Intermediate course

Graphs from pivot tables

I have created a stacked graph, but would like to show the changes in that stacked graph from i.e. 3 months ago. How can this be done?

For upcoming training course dates see: Pricing & availability

Reply Mon 23 Aug 2010, 12:33Trainer Nafeesa said...

RE: graphs from pivot tables

Hi Sumayyah

Thank you for your question regarding the stacked chart.

Sorry for the delay in getting back to you. If you could bear with me for another day or so & we'll endeavour to get an answer to you

Kind Regards,

Nafeesa

Microsoft Office Specialist Trainer

Reply Mon 23 Aug 2010, 14:31 Edited on Tue 24 Aug 2010, 10:33Delegate sumayyah said...

RE: graphs from pivot tables

Hi Nafeesa,

No problem, I've got a few more questions. I've figured out how to get the "% difference" and "% of"part. However, I want to be able to show the graph in currency and then add data labels "% of" in percent. It doesn't seem to let me do this. Any idea of how best to tweak this?

Is there a way to you my stacked graph please? The percentage just doesn't match the axis. :) No idea whats happening.

Excel articles

· Some Examples Of Excel Text Formulas
· Do You Really Need Excel VBA Training?
· Backstage Management With Excel 2010
· Update Your VAT Rates In Excel
· Microsoft Office and the Small Business: Part 1 Excel

Please browse our web site to find out more about
microsoft excel course and other Microsoft training courses.

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips