I currently have a worksheet that I have five charts on. Four of the charts are stacked bar charts and the other chart is an x-y scatter chart. The 4 bar charts are plotted along side each other, and the X-Y chart is plotted next to the 4th bar chart. The '0' point on the Y axis is the same for all the charts, and the scale for the Y axis is the same. I have used VBA code to set the Y scales all the same, taking into account the min and max values and stretching or shrinking the remaining Y axis to be equal. What I need to do is to be able to synchronize the zero point on all five graphs to the same place on the paper, so by looking across the charts, you can compare Y axis values.
Is there also a set scale feature in Excel that would allow me to choose a scale for the X and Y axis, like 1 inch = 50 foot?
Is there also a set scale feature in Excel that would allow me to choose a scale for the X and Y axis, like 1 inch = 50 foot?
