Combination charts for showing mixed data

Combination chart

Combination charts A combination chart uses two or more chart types to emphasize that the chart contains different kinds of information. The chart in the example above shows one data series (Projected) as a column chart type and the other (Actual) as a line. To create this kind of overlay effect, change the chart type for one or more of the data series in the chart.

Combination chart with secondary axes

Secondary axis When the range of values for different data series varies widely, or when you have mixed types of data, you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series. The chart in the example above shows the number of homes sold on the left y-axis and the average price on the right y-axis.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.