In this scenario, the third series does not display as a separate chart type by itself. For example, if you create a three-series chart in line format, turn one data series into a column chart and try to transform the third series into a doughnut chart, the result shows your first series as a line, the second as a column behind the line and all three series as a doughnut behind the other two data series. If you try to turn a data series into a chart type that requires more than one series, Excel adds the new chart using the data in all your data series.Well, I really didn’t HAVE to create the chart in Excel, but others needed to be able to update the chart and they, gasp, don’t have a Tableau license. Tableau makes this task incredibly easy, but I needed to do this in Excel.

Each time you redefine a data series as a contrasting combination chart type, Microsoft Excel displays it behind the series you previously defined. I needed to create a dual-axis chart, with two bars on the primary axis and a line on the secondary axis.For the same reason, if you combine two chart types that present information similarly but in different orientations - for example, a column and a bar chart - you may be unhappy with your output. If you combine two charts of the same type, your results may be difficult to understand because of the lack of visual differentiation between them.In the last step, you might need to make. Finally, set the desired values on Minimum/Maximum Bounds and on Major Unit text boxes. On the Format Axis menu that will appear, select the Axis Options tab. If your chart data includes more than two series, you can create a combination chart that uses three different chart types, one for each series. Step 2: Adjust the scale of the secondary Y-axis: Select the secondary Y axis by right-clicking on it.

Use secondary axis in excel for mac