How to change min/max values in Excel chart?

[nleahcim]

Hi - I want to set the min and max values of the X axis on an Excel chart based upon data entered into two cells. This is the code I wrote:

Please Login or Register  to view this content.

The problem is that the code seems to do... nothing. I have named the two charts RLCMagnitude and RLCPhase. The lower and upper bounds are in E4 and F4. Any ideas?

I should mention that the only reason I want to do this is that Excel isn't automatically choosing sensible lower bounds for my plot. My x scale is logarithmic and it always has the minimum bound set to 1, no matter what the smallest value being displayed is. It does seem to intelligently set the upper bound. Strange.

One last question - is there a better way to do the "If Target.Address = "$E$4" Or Target.Address = "$F$4" Then" line for if you want to check if the selected cell is included in a large range of cells (ie anything between rows columns E and Z and rows 4 and 6) ie something like "if Target.address exists in [E4-Z6] then". Hopefully that made sense.

Thanks!

[TMS]

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

I prefer the first approach.


Put a Stop as the first line of the event code. Then step through the code to see what it is doing.


Regards, TMS

[nleahcim]

Thanks TMS! Your solution worked well for checking the range.

As for why my code above wasn't working... well, it is now, even without changing anything. I have no idea why it wasn't working last night. Maybe it was and I was just too tired to notice. No idea...

[jeffreybrown]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[TMS]

It may just have been that event handling had been switched off somewhere along the way ... and you have reset it.

But, whatever, it's doing what you want now and you have a mechanism for diagnosing faults in the future.

Thanks for the rep.