It's often helpful to create charts that compare different types of data. For example, you might want to compare overall revenue with the number of units sold. To do that you need to know how to use different chart types in one chart and how to use a secondary vertical axis to plot values that are in a different value range. Read more to learn how. (Sample workbook included) ...( read more ) Read More...
Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2012/06/21/combining-chart-types-adding-a-second-axis.aspx
Jun 21 2012, 11:43 AM