Check out my Blog: Ever see those charts where there is a column chart and a line chart in one? Also there are two y axis that show ranges on values on both the left and right side of the chart? Well this is called a combination chart and it's commonly used to show two series of data together. I see this most in stock price type of charts where the column charts shows the volume of stock trading activity and the line chart shows the stock price. It's actually fairly easy to create this type of chart and it's a great way to show multiple views of data in one chart. See the video to learn how it's done.

The Mac version does not have the 'Change Chart Type' tab for 'All Types' and Combo type is missing. Interestingly, I created a two axis chart in Excel for Windows then opened in Excel for Mac (both 2016) and now several menu items are available! Hp officejet pro 8600 plus. For instance, in creating it in Mac the 'Add Chart Element' only showed primary axis as an option.