I'm trying to measure the length of the x-axis of a graph so that I can use it as an input.
Any ideas?
I'm trying to measure the length of the x-axis of a graph so that I can use it as an input.
Any ideas?
If your data is in A column use: =MAX(A:A)-MIN(A:A)
Is that it?
No not quite. If I change the size of the graph window the x-axis physically gets longer. I'd like to measure the length (units of measurement) of hte x-axis...
Do you mean you want the axis object's Width property, or do you want the range (i.e. the maximum value less the minimum value)?
Remember what the dormouse said
Feed your head
After the width property
Please don't forget to mark this 'Solved' then.
But how do I assign a macro (assuming this is the way to go about it) to fetch the width of the graph so that I can use it as an input?
An input for what?
Input is probably not the best choice in words...
I would just like to measure and return a numerical value of the length of the x-axis back into a cell so that it can be used.
Please Login or Register to view this content.
Sweet thanks mate I'll give it a go
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks