I have created graph like this….
Where one is stacked bar chart and other is Bubble chart (Data points).
As you can see the column size of both the charts are same.
Is it possible to increase the size of Bar chart column and Decrease the size of the Bubble chart column. I mean to say I want to increase the space taken by Bar Chart and Decrease the Space taken by Bubble chart .
Please suggest me the way around on this.
One way round this is to create the two views in different sheets and then combine them on a dashboard. That way you can control the size of each axis independently.