autoscale

  1. B

    Use autoscale on chart but prevent major unit <1?

    Hi, I need the y-axis on my chart to autoscale, so that the major units will be 5, 10, whatever, as appropriate, when the values are large. But sometimes the values will be very small and the autoscale sets the major unit to 0.5. I am counting people who meet certain criteria, so this is not...
  2. E

    vba code to autoscale y axis

    I have a sheet that has several different series in a chart i created. i need to autoscale the y axis with the chart. The way my sheet works is I press a button and the sheet jumps to the graph. What i would like to do is when the button is pressed to select the graph to view is add a line of...
  3. K

    Graph Auto Scale Not Working

    We just upgraded from Excel 2003 to Excel 2007. I have graph where I can use a drop down to select different departments to view. Since the upgrade the "auto" scale on the Y axis is not working on some of the graphs. Some display properly and some do not. The scale is way too high. I also have...
  4. R

    Auto Y-Scaling Chart

    Hi, I'm using this code to update the scale of a chart on the active sheet. I would like to move this chart to a different tab, a chart one, but I'm not being able to update the code to work, any ideas? Select Case Target.Address Case "$A$2"...

Watch MrExcel Video

This Week's Hot Topics

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
Top