I've attached the chart I'd like to change the formatting on, but I'm not sure if it's possible and searching hasn't yielded anything useful yet.
In the attachment, I'd like the LH106 Sed, LH104 Sed, and LH102 Sed series to all side-by-side and the LH106 Volume, LH104 Volume, and LH102 Volume series also be side by side but directly behind or in front of the corresponding 3 data series.
I'm demonstrating it using a 3D column chart which is what I want, but a 2D column chart with the Sed data series on the primary axis and the Volume data series on the secondary axis seems close if I could just convert it to a 3D chart. When I have the Volume series on the secondary axis and try switching the data series/chart type to 3d column, Excel warns me "You cannot combine 2-D and 3-D chart types."
I suspect the chart type I want can't be done in Excel, but maybe someone can help.
Thanks
Shea
Bookmarks