I need a macro code that will set the max and min Y values of a line graph equal to that of an existing graph on the worksheet that is set to auto fit the data point. For example if Graph 1 auto fits the data to Max .05 Min -.05 Y axis, i need Graph 2 to then have these values.
Are you familiar with Excel's object model? https://msdn.microsoft.com/EN-US/lib.../ff834649.aspx
It should be as simple as
1) Read the .maximumscale and .minimumscale properties of the y axis of Graph 1
2) set the .maximumscaleisauto and .minimumscaleisauto properties of the y axis of Graph 2 to False
3) Write the values from step 1 to the .maximumscale and .minimumscale properties of the Y axis in graph 2
What parts of this do you need help with?
Originally Posted by shg
I am not familiar. I need help with the actual code to complete steps 1-3 in your response.
Well, now is a good time to start to become familiar with Excel's object model. Did you look at the help file at all? Using the example given as a starting point:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks