Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Easily Combining Excel Charts

December 2, 2015 by Tyrone Pernsley

Combine Charts image1Learn Excel Now brings you our tip of the week: easily combining Excel charts. In this quick guide, we aim to provide you with methods for quickly and easily combining Excel charts. This feature is useful for comparing and contrasting your data when using Excel in the workplace.                                 

What is a Combination Chart?

A combination chart consists of at least two data series that use different chart types. The purpose of using a combination chart is to view numbers with extreme differences in value. A secondary value axis represents the second set of numbers making it easier to see the differences. (**Bubble charts and 3-D charts can’t be used for combination charts.)

Create a Combination Chart:

First select all the data that you want included in your combination chart, then click “Insert” and choose “Chart” where you can select the type of chart you want to use. After creating the chart, go to “Chart Tools” and under “Layout” click on “Current Selection Group” and then select the secondary data that you want plotted on the chart. Next click on “Format Select” and then choose “Plot Data on Secondary Axis.” To pick what type of chart you want the secondary chart to be, click on “Design” in the “Chart Tools” tab and select “Change Chart Types.” Finally, select the type of chart that you want your secondary chart to be and click ok. Your data will then be displayed as two different types of charts on the same chart.

Combine Charts image1

What is a Trendline Chart?

Trendlines show projected trends forecasted over time, based on your current data. There are six types of trendlines:

  • Exponential: Used when data increases or decreases at increasingly higher rates
  • Linear: Used for straight lines with linear data
  • Logarithmic: Used when data increases or decreases rapidly and then levels out
  • Polynomial: Used when data increases and decreases
  • Power: Used to compare numbers that increase at a certain rate
  • Moving Average: Used to smooth changes in data, showing a pattern of change

Combine charts image2

Trendline Chart

To add a trendline to your chart, click on the chart, then go to the “Chart Tools” tab and click “Layout.” Select “Analysis Command Group” then “Trendlines” and finally select the type of trendline that you want to use. You can format your trendline by changing the line color and style. To verify how accurate and reliable your trendline is, look at its R-squared value by selecting the “More Trendline Options” on the “Trendline” icon on the Chart Layout tool bar. Then, check the box “Display R-squared value on chart” on the bottom of the options. The closer the R-squared value is to 1, the more reliable the trendline.

Liked this Excel combined charts guide? Have questions? Leave your comments below; we’d love to hear from you.

Getting Social with Excel: Spread the word and share the knowledge!

Kevin – Learn Excel Now

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In