Are you familiar with Excel's object model? If not, I would recommend that you become familiar with it (I think the answer to most of these kind of questions is really about how to find the desired object and property/method in the object model): https://msdn.microsoft.com/en-us/lib.../ff194068.aspx
I'm not sure where you would want it to appear in your code, but the basic ideas will be:
1) Identifying which chart using the desired_workbook.charts(chart_identifier)
2) then identifying the axis .axes(xlvalue)
3) then reading the major unit of that axis .majorunit.
4) Assign that to a variable or to a cell value.
You should be able to access the help files for all of those collections, objects, and properties from the object model link above.
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by shg
Bookmarks