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