Is it possible to make a 3D column chart where one series is plotted on a secondary axis?
Ideally, I would like to use the 3D column column subchart type (bottom left hand column of the chart type selector). This chart type allows comparison across categories and series. Alternatively, a clustered 3D chart type would also work (middle left hand column of chart type selector).
I can get a flat 2D clustered chart to plot series2 on a secondary axis. But when I try doing the same thing on either of the 3D options, when formatting series2, the axis tab is missing, so I can't specify the secondary axis.
I've attached my example of what I've tried.
Any ideas or fixes?
Thanks, cat
Bookmarks