Charts in excel

The UK's most regular instructor-led training courses.
Training information: excel-xp-training · Microsoft+excel+training · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

2 posts

ReplyThu 4 Feb 2010, 16:22Delegate 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.

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	4		£207	£212
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
2007	Tue 30 Mar 2010	Southwark	5		£199	£204
2003	Thu 1 Apr 2010	Bloomsbury	4		£207	£212
Full Schedule: See all 77 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

755 posts

ReplyFri 5 Feb 2010, 15:44Trainer 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

2 posts

ReplyFri 5 Feb 2010, 16:06Delegate 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

755 posts

ReplyWed 17 Feb 2010, 10:35Trainer 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

· Microsoft Excel Features and Functions for Accountants
· So what's new in Excel 2007?
· Improve Performance Of Your Excel Macros
· Microsoft Excel can ensure you keep on top of your finances
· Crazy Things People Have Done With Excel

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

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.