Secondary Axis Creates Stacked Bar Chart

herestheblag · Jul 11th 2007

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

xlite · Jul 11th 2007

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.

xlite · Jul 11th 2007

Re: Secondary Axis Creates Stacked Bar Chart

another option is to differentiate the width of the bars as shown
in Andy's chart example:

http://www.andypope.info/charts/stackedwidth.htm

Fin Fang Foom · Jul 11th 2007

Re: Secondary Axis Creates Stacked Bar Chart

Hopefully this come close what you are looking for.

Secondary Axis Creates Stacked Bar Chart

Participate now!

Share