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

excel vba courses london - Charts

ResolvedVersion Standard

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

Jane has attended:
Excel Advanced course
Excel Pivot Tables course

Charts

why doesn't my pie chart show segments

Mon 23 Jul 2007, 11:01 Trainer 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

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

excel vba courses london - Charts

Charts

RE: charts

Excel articles

Excel tip:

Convert a column into row quickly in Excel 2010