lionelhill
Technical User
I do all my plotting outside Excel, so I'm stumped with this question that came from a co-worker.
They are plotting vertical bar charts, but one group of data is on a much larger scale than all the remaining data. They therefore want a secondary axis.
I got as far as plotting all data, selecting the set of bars that are unreasonably large, and using format - axis - secondary axis to put them on a different axis on the right hand side.
But now we have the small bars plotted OK, with the large ones plastered indiscriminately across the middle of each cluster of bars, printed in the foreground, obscuring everything else.
Is there a way to keep the large bars in their original position on the x-axis, neatly to the right of the cluster of low-value bars?
Sorry if this is a stupidly trivial question. I'm sure it ought to be ludicrously easy; after all, why bother offering a secondary axis in bar-charts if it gives unreadable results?
They are plotting vertical bar charts, but one group of data is on a much larger scale than all the remaining data. They therefore want a secondary axis.
I got as far as plotting all data, selecting the set of bars that are unreasonably large, and using format - axis - secondary axis to put them on a different axis on the right hand side.
But now we have the small bars plotted OK, with the large ones plastered indiscriminately across the middle of each cluster of bars, printed in the foreground, obscuring everything else.
Is there a way to keep the large bars in their original position on the x-axis, neatly to the right of the cluster of low-value bars?
Sorry if this is a stupidly trivial question. I'm sure it ought to be ludicrously easy; after all, why bother offering a secondary axis in bar-charts if it gives unreadable results?