Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Charts

	98.1 % recommend us
	More live stats...

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

Training information:

excel vba courses london - Charts

Resolved · Low Priority · Version Standard

Reply Thu 19 Jul 2007, 14:36Delegate Jane said...

Jane has attended:
Excel Advanced course

Charts

why doesn't my pie chart show segments

For upcoming training course dates see: Pricing & availability

Reply Mon 23 Jul 2007, 11:01Trainer Tracy said...

RE: charts

Hi Jane,

Thanks for the posting.

There are a couple of reasons why this could happen please check the following and let me know

It may have something to do with how you have initially set up your table. Make sure it has the appropriate row and column labels, feel free to email over your spreadsheet if you like. Go into the Chart menu and down to Source data and toggle between rows and columns and see what that does.

You can always reformat, each section by double clicking on the segments individually and changing the colours.

Tracy

Excel articles

· How To Create An Argument With Excel
· How To Use The Subtotal Function In Excel
· Understanding XML Within Excel
· Do You Need To Run Excel 2007 In Compatibility Mode?
· Special Characters in Excel

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips