logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
European Travel
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel


dailyclick
All times in EST

Full Schedule
g
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor

g

Combination Charts in Excel

Guest Author - Chris Curtis

When you are looking at related data containing data elements are widely disbursed, you will need to define a secondary axis to properly depict the relationship between the two. For example, you may want to make a comparison between the number of races won and career earnings by top Nascar Drivers. Since the number of races is a small number (less then 100) and the career earnings is a large number (more than 1 million) V a bar chart is unable to create a single axis to display both numbers in a meaningful way.

You can use a combination chart by creating a secondary axis and using a line style for the smaller number. Let's give it a try.

Input the data as shown below:



Create a Basic Chart
Select the entire data range
Press F11

Observe that the basic chart appears to have only one data series, Earnings. The reality is that the number of races won is represented on the chart but is flatlined on the bottom axis because the number of winnings is so small in relationship to the amount of career winnings.



Because the scale for these two data elements are widely disbursed, you need to define a secondary axis to properly depict the relationship between the two.

Define a secondary axis for the Number of Races Won
Click on the Chart Objects drop down
Select Series Wins
Right click on one of the selection squares representing the Series (you will see them along the category access at the bottom). Making this selection is tricky so watch the tool tip to make sure you are selecting the Series instead of the plot area or category Axis
Click on Format Data Series
Click on the Axis Tab
Select Secondary Axis
Click on OK

Observe Data Markers are combined and therefore, not meaningful


Redefine chart type for the "Wins" series
Right click on the "Wins" series
Click on Chart Type
On the Standard Type tab, select Line Chart
Select Line with data marks at each data point
Click on OK

Observe the chart results. By using a secondary axis and combination chart, the relationship between the number of points won and career winnings is displayed in a meaningful chart. The chart should now look like this.



Now you have a chart that can be interpreted and from which some observations can be made.

Add Combination+Charts+in+Excel to Twitter Add Combination+Charts+in+Excel to Facebook Add Combination+Charts+in+Excel to MySpace Add Combination+Charts+in+Excel to Del.icio.us Digg Combination+Charts+in+Excel Add Combination+Charts+in+Excel to Yahoo My Web Add Combination+Charts+in+Excel to Google Bookmarks Add Combination+Charts+in+Excel to Stumbleupon Add Combination+Charts+in+Excel to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the Desktop Publishing / Ebooks Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Laura Nunn for details.

g


g features
Becoming a Fiction Editor

Making a Background Transparent Using Photoshop

Merging Letters in Word 2007

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor