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

Related Excel Tutorials