Hi
I have some code which creates 3 bar charts
1st Chart % between 40 and 120
2nd Chart count between 8 and 100
3rd Chart count between 200 and 5000
the code makes the charts identical in size in some instances this works great and makes the data easy to read.
Normally what happens is Chart 2's Vertical (Value) Axis is narrower than the other charts which makes the plot area wider.
Is there a way to set the plot area size of the bar chart without this affecting the axis size, alternatively can I change the Vertical (Value) Axis width.
The code i'm using for the width is
but this includes the axis
Any help is greatly appreciated
I have some code which creates 3 bar charts
1st Chart % between 40 and 120
2nd Chart count between 8 and 100
3rd Chart count between 200 and 5000
the code makes the charts identical in size in some instances this works great and makes the data easy to read.
Normally what happens is Chart 2's Vertical (Value) Axis is narrower than the other charts which makes the plot area wider.
Is there a way to set the plot area size of the bar chart without this affecting the axis size, alternatively can I change the Vertical (Value) Axis width.
The code i'm using for the width is
Code:
ActiveChart.PlotArea.Select
Selection.Left = 20
Selection.Width = 490
but this includes the axis
Any help is greatly appreciated