charts excel
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

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

resolvedResolved · Low Priority · Version 2003

No ranking yet
2 posts
replyReplyThu 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.

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

Platinum
755 posts
replyReplyFri 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

No ranking yet
2 posts
replyReplyFri 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

Platinum
755 posts
replyReplyWed 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


Related articles

· 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.

View all Excel hints and tips


Rate this page:
2.1/5 (108 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard