axis scale

  1. S

    Autoscale chart X & Y axes dependent on table values & re-run macro after changing input

    I have a chart embedded in a worksheet plotting 2 parameters. I need to do 2 things. 1. I want to use VBA to dynamically scale the axes whenever the data table updates. The input table is in sheet1 The chart is in sheet 2 Code similar to that below would perform the function required, but i'm...
  2. T

    Change axis bounds in Excel based on data

    I am creating many line graphs and would like to know of a way to change the vertical axis bound minimum and maximum based on the data itself? For example for set of data, the amounts ranges from 6 million to 12 million while another data set ranges from 3 thousand to 5 thousand. Same graph just...
  3. R

    Keeping static x-axis with new series

    Hello- My initial program generates a few iterations of similar charts depending on how many sets of 32000 datapoints there are. The X-axis is Date & Time, and Y-axis are different variables. I want to add a subroutine which plots an additional series from another page onto each of these plots...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top