Forum Discussion
Excel scatter chart with fixed size and scales
When I use the recommended scatter chart feature it creates charts of varying sizes and scales. All my data sets fit within a 100 by 100 matrix and I want to fix the size, shape and scaling of the chart. How can I do this?
In Scatter plot (attached herewith), you can set circle size, color, trend lines for each metric, R-Square metric, most interested quadrant selection, more info you can find here.
You can find the detail how-to video here.
Thanks,
It would probably require VBA to make the charts uniform.
