I have several pivotcharts in a sheet and their pivot tables on a separate sheet. I am stumped on a code that will return the maximum and/or minimum value from the pivot chart. My charts have bars and scatter points but all I need is the largest value that exists in all the data the pivot chart reflects.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
