Some times you may come across a situation where you want to show 2 variables in one Excel chart.

For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables.

Well you can certainly combine a Column graph with a Line graph to compare the data and have two separate axes.

Below I show you how you can do this in a few simple steps.

DOWNLOAD WORKBOOK

Column with a Line2

 

Helpful Resource:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Apply Custom Chart Styles Excel's default Charts are bland and ugly but you can certainly spice them up to your liking. Using the Shape Styles group in the ribbon menu you can customize your Excel chart the way you or your boss wants. There are several formatting options including Shape Styles, Shap...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...
Excel Chart Layouts When you create an Excel chart you can choose from 11 different custom Chart Layouts. This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button. From this selection you can show your Chart with or without t...