When ever I add a secondary axis to my chart my bar chart sub type changes to a stacked bar chart. How do I keep the sub type bar chart? I have attached an example. I have tried playing with the gap and width of the bars but to no avail.
Thanks for any help on this
Re: Secondary Axis Creates Stacked Bar Chart
hi,
when you added a secondary axis to the chart, the series actually overlaps the first one
therefore hiding the first series behind it.
one solution maybe to adjust the scale of the secondary axis.
i changed the max to 10 and both series are shown.
Re: Secondary Axis Creates Stacked Bar Chart
another option is to differentiate the width of the bars as shown
in Andy's chart example:
Re: Secondary Axis Creates Stacked Bar Chart
Hopefully this come close what you are looking for.
Don’t have an account yet? Register yourself now and be a part of our community!