Stacked bar charts alongside each other showing same y-axis scale

[Tom Nice]

Hi there,

I've created three stacked bar charts alongside each other and basically want them to use the same scale of values so that gridlines all match up and that the bars are at the right scale. The attached workbook shows what is happening to the charts where the scale changes due to the selected data.

'Invisible' columns have been used as the columns that stack on top of the data that I want to be shown which I will refer to as ChartData. They have been calculated by using the maximum value that this dataset contains - so for each column of ChartData the max value from the whole dataset will be subtracted in order to get each chart at a consistent 'height' in the stacked bars.

What I am hoping to do is keep everything to the same scale and also to make the best use of chart area space i.e. so the y-axis range doesn't stop at a whole interval above the max value leaving unecessary white space.

I hope this all makes sense as well! And that someone will be able to assist with this.

Thanks very much,

Tom

 

[Hui]

Do you mean like this?

 

[Tom Nice]

Hi Hui,

In terms of scale that is what I'm aiming for but still want to separate out the charts lined up next to each other. You think that's possible without VBA?

Thanks

 

[Hui]

Pick a value greater than the maximum chart value eg: 400k
Set 3 series called Filler 1, 2 & 3
Which will have values =400k-x
Then add a new series to each original chart



Then color the new series blank



see attached file:

 

[Tom Nice]

Hi Hue,

That's great and should do the trick.

Many thanks,

Tom