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

Sparklines: Column Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell.  A Column Sparkline is best used when you have lots of data points. You can style them in different colors and add a marker for the High and Low points of your data.  As your da...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function. The RPT function uses the vertical bar character | as the first argument: text and references the va...
Dotted Line Organizational Charts You can create Organizational Charts in Excel using SmartArt which I go through in this post here:   Organizational Charts in Excel You can also extend this concept to create a Dotted Line Organizational Chart but we need to think outside the square a little bit to make this h...
Stock Line Chart Using Excel Ever had a lot of historical stock data closing prices and you want to visualize how it is going so far? You can actually use the good old Line Chart in Excel to create your own Stock Line Chart! Below is the data source that we are going to use to create our Stock Line Cha...