The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Charts using 3 sets of data

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Charts using 3 sets of data

Resolved · High Priority · Version 2007

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

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

For upcoming training course dates see: Pricing & availability

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

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

RE: Charts using 3 sets of data

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

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.

Powerpoint articles

· PowerPoint Advanced Techniques
· Considering Font In PowerPoint Presentations
· That Was The Worst PowerPoint Presentation I've Ever Seen
· What Is Pecha Kucha and How Does It Affect PowerPoint?
· Save Time By Using AutoCorrect In PowerPoint

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

Powerpoint tip:

Create own ribbon tab - PowerPoint 2010

a. In PowerPoint click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Powerpoint hints and tips

How are you able to embed images into Expression Web for HTML emails?