VBA Code to Auto Adjust Chart Axes Dependent Upon Cell Entry

**rhenry54** · 09-06-2017, 03:29 PM

I have an excel chart that I want to always be symmetrical. I am trying to write a code so that my chart will automatically adjust the x and y axes according to the value entered in a cell. The code I am using doesn't seem to be working so I am reaching out for help. Below is the code I have now and a picture of the spreadsheet. Any help would be GREATLY appreciated.

Please Login or Register  to view this content.

**protonLeah** · 09-07-2017, 05:21 PM

Try putting an activeX commandbutton on the sheet with:

Please Login or Register  to view this content.

VBA Code to Auto Adjust Chart Axes Dependent Upon Cell Entry

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code to Auto Adjust Chart Axes Dependent Upon Cell Entry

Re: VBA Code to Auto Adjust Chart Axes Dependent Upon Cell Entry

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Code to Auto Adjust Chart Axes Dependent Upon Cell Entry

[SOLVED] How to adjust row height of row so tall the point to grab to adjust auto falls below

VBA code for pulling a sequential number from a text file dependent on a form entry.

Custom number format code for hiding specific values on chart axes

[SOLVED] The VBA code to auto-clear dependent drop down selection when parent cell change.

Auto Adjust VBA Code

Merging code for hiding columns and setting chart axes values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions