Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts in excel

Charts in excel

ResolvedVersion 2003

Thu 4 Feb 2010, 16:22 Delegate Nicole said...

Nicole has attended:
Excel Advanced course

Charts in excel

Is it possible to make a greater variety of pie charts than is currently available on 2003.

Fri 5 Feb 2010, 15:44 Trainer Stephen said...

RE: charts in excel

Hi Nicole

Thanks for your question

Could you give me some idea as to the sort of features you would like your pie charts to have. I will then explore the problem and see what can be done.

Thanks

Stephen

Fri 5 Feb 2010, 16:06 Delegate Nicole said...

RE: charts in excel

I was looking to make circles that are sized relative to the value they represent. Like on this website..

http://37signals.com/svn/posts/1585-where-is-your-money-going-from-the-new

Thanks
Nicole

Wed 17 Feb 2010, 10:35 Trainer Stephen said...

RE: charts in excel

Hi Nicole

The example you give looks like a bubble chart.

This measures three variables with the vertical and horizontal position of the bubble measuring the first two, and its size the second.

If this is what you need then the bubble chart is a standard form given in the chart wizard

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips

Charts in excel

Charts in excel

RE: charts in excel

RE: charts in excel

RE: charts in excel

Excel articles

Excel tip:

Pivot table grouping