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 » Pivot chart

	98.1 % recommend us
	More live stats...

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

Training information:

Pivot chart

Resolved · Low Priority · Version 2003

Reply Fri 19 Sep 2008, 16:22Delegate Suliaka said...

Suliaka has attended:
Excel Advanced course

Pivot chart

can you use custom chart formats with pivot charts?

For upcoming training course dates see: Pricing & availability

Reply Thu 25 Sep 2008, 11:54Trainer Greg said...

RE: pivot chart

Hello Suliaka,

The answer to your questions is Yes. You can use custom chart formats with pivot charts. All you need to do is to create a pivot chart as you usually do, then make sure you have the Pivot Table toolbar visible. Click on the Chart Wizard button from the Pivot toolbar, then select the Custom Type tab from the Chart Wizard dialogue box.

I hope this helps. If there are further questions, please contact us.

Thank you.

Greg Eze
BEST STL training

Excel articles

· Excel: Save Time With AutoFill
· How to Create Better Excel Spreadsheets: Part Four
· Plug Into The Big Grid
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· The Secret Formula To Creating Correct Calculations In Excel

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

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips