Two most commonly asked or searched queries when it comes to charting are,

• How to combine two chart types in one chart, like a line chart combined with bar chart?
• How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis?

Excel combination charts are a great way to combine two chart types in to one.

Using data series options you can plot a particular series on secondary axis.

In this quick video tutorial you can learn how to make a combination chart and add secondary axis in less than 15 seconds.

Watch it on youtube: Creating combination charts and adding secondary axis – video tutorial

More quick tips and video tutorials:

• How to remove duplicates
• Hide cell contents using formatting codes
• Hide formula errors when printing
• Editing formula references quickly using mouse
• More quick excel and charting tips

Comments

RSS feed for comments on this post. TrackBack URI

Leave a comment

   Name (required)

   E-mail (required, never displayed)

   URL

Notify me of when new comments are posted via e-mail

If you have an excel or charting question, please ask in the forums Click here to join our discussion forums