Excel Column Chart with Primary and Secondary Axes ...
Oct 28, 2013 · Start by making a plain old column chart. Format the Secondary series so it is plotted on the Secondary Axis. The Primary axis is scaled from 0 to 10, and the Secondary axis from 0 to 200. We need to adjust these scales so the Primary panel is in the bottom half of the chart, and the secondary panel in the top half.
Column Chart With Primary and Secondary Axes:Use A Panel Chart InsteadIt's hard to make column charts with primary and secondary axes; special steps must be taken to prevent secondary columns from obscuring primary co...What People (Think They) Want:Column Chart With Two AxesLet's use some simple data to illustrate the situation. Here the Secondary data is more than an order of magnitude greater than the Primary data.Wh...What People Really Should Use:Panel ChartIt's okay to use primary and secondary axes in the same chart, but to avoid confusion, it's best to separate them into separate panels of the chart...