Hi!
I am using primary and secondary axis for creating overlapping bars using VBA. The problem is that there should be same scale for both axis, which changes (every time I run the code, there can be different Max value). I was thinking - is it possible:
1) to find max value in column E and assign this value to variable "variable_containing_max_value";
2) Put this variable as maximum scale something like this:
3) The same for secondary axis.Please Login or Register to view this content.
Thank you very much!
Bookmarks