Tips and guides Microsoft 365 Enterprise Published June 21, 2012 4 min read Combining chart types, adding a second axis 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.