Charts using 3 sets of data

The UK's most regular instructor-led training courses.
Training information: powerpoint training in · Powerpoint training · Microsoft PowerPoint Training UK
See also · powerpoint training · powerpoint.course · powerpoint advanced

Resolved · High Priority · Version 2007

3 posts

ReplyTue 10 Nov 2009, 09:20Delegate Kathryn said...

Kathryn has attended:
Powerpoint Intermediate Advanced course

Charts using 3 sets of data

Hi, please could you let me know how to create a bar chart using 3 sets of data. e.g. the bottom axis would have the categories O&G, M&M, Chemicals, Utilities, up the side would be the numbers, but i want to split the bars up into different colours to signify the number of people at each level within each category. i.e. 2 MDs, 2 VPs and 1 Analyst in O&G, all to be represented in 1 bar. Thanks v much

Version	Date	Location	Places available	Book	Next place rate (£)
Powerpoint Intermediate Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 26 Mar 2010	Bloomsbury	3		£235	£240
2003	Fri 26 Mar 2010	Southwark	0	FULL
2003	Mon 29 Mar 2010	Bloomsbury	3		£235	£240
2007	Thu 1 Apr 2010	Limehouse	4		£224	£225
2007	Tue 13 Apr 2010	Bloomsbury	9		£182	£187
2007	Fri 16 Apr 2010	Limehouse	6		£212	£217
Full Schedule: See all 28 Powerpoint Intermediate Advanced course dates. Bookings currently available until 16th December 2010.

336 posts

ReplyTue 10 Nov 2009, 13:44 Edited on Tue 10 Nov 2009, 13:47Trainer Anthony said...

RE: Charts using 3 sets of data

Hi Kathryn, thanks for the query. You need to lay out your data in Excel like this, simplified, example:

Headings
A1(blank), B1 = "M&M", C1 = "Utilities", etc
Then in successive rows
Column A: "MD", B2 = 2, C2 = 4
Column A: "VP", B2 = 1, C2 = 2
Column A: "MD", B2 = 1, C2 = 1

Select the data, and using the wizard create a stacked column chart. On the Data Range tab of step 2 of the chart wizard, change "Series In:" to Rows. That should result in the chart you need.

Let me know if you need anything else.

Anthony

3 posts

ReplyTue 10 Nov 2009, 13:51Delegate Kathryn said...

RE: Charts using 3 sets of data

Anthony, thank you. How do i use the wizard?

336 posts

ReplyWed 11 Nov 2009, 13:28Trainer Anthony said...

RE: Charts using 3 sets of data

Hi Kathryn. Select the data and then on the Insert menu click on Chart. Select the top middle Column chart style option (stacked column) and then click Finish. It should be as simple as that!

All the best,

Anthony

Wed 18 Nov 2009: Automatically marked as resolved.

· Microsoft PowerPoint gets your message across
· Give Your PowerPoint Presentations More Impact
· Go Green With Support Materials And PowerPoint
· Slide Libraries, Giving You The Power To Present Yourself In The Best Light
· The Three Components of an Effective PowerPoint Presentation

Please browse our web site to find out more about
powerpoint training in and other Microsoft training courses.

Powerpoint tip:

Removing unused toolbar buttons in PowerPoint

Are there buttons on your PowerPoint toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the PowerPoint window. When you release your finger from the mouse, the button will disappear.

View all Powerpoint hints and tips