Charts

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

Resolved · Low Priority · Version Standard

Charts

Emily has attended:
Powerpoint Advanced course
Excel Intermediate course

by - delegate Emily [10 posts] (2008 Mar 5 Wed, 23:08) Reply

I need to do a basic chart with for example the following. (I already know the percentage, without numbers)

shop in Camden, 20%
shop in highgate, 30%
shop in islington 40%
shop in west london 12%

How can I show this in a chart

Or is it possible to show two places with 100%? Which chart is the easiest to use. And can you add the data without an excel spreadsheet?

I would really appreciate some help with this, its for a job tomorrow, I hope I have made sense.

Kind regards

Emily

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: charts

by - trainer Rich platinum contributer [711 posts] (2008 Mar 9 Sun, 10:55) Reply

Hi

For percentages like this a pie chart is standard. Your values here add up to 102% though which wont work. Pies must add up to 100. For charts like this its actually much better to use the original numbers and let excel work out the percentages for you. Go to insert>>chart and select pie. click next and in the data range box you should select the data you want to use. Click next and on the data labels tab select 'Show percentage' and click finish. This will give you a basic pie chart which can be formatted in various ways so best to have a play.

If you have to use the data above then i would go for a bar since bar will not change your percentage values.

Please see the two tabs in the attached sheet for an example.

Thanks
Rich

Attached files...

Chart Examples.xls

· How to Create Better Excel Spreadsheets: Part Four
· Reasons Why VBA for Excel Training Fails
· A Beginners Guide To Formulas In Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Features of Microsoft Excel that assist in Analysis of Financial Data

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

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips