I have two broader questions stemming from the one I asked last year in "J-Walk Chart Tools alternative?"
where I found the the free standalone Walkenbach "J-Walk Chart Tools" was too out of date to work with modern Excels.
Other threads show that his commercial Power Utility Pack (PUP 7) product is no longer available.
So, Walkenbach's "Chart Report" add-in is no longer available to newcomers.
(It produces a detailled report that documents a chart's many settings, or produces a report that documents all charts.)
In the meanwhile, has anyone written a similar chart documention tool?
I have not found any similar add-in out there, and was attempting to simply use screen shots to record some of my charts customized settings, in Excel 365, but found that what the Options screen showed was wrong.
E.g., Format Axis, Axis Options, Axis Position, showed the radio button for "Between tick marks" selected, when in fact the chart had "On tick marks" actually.
Also, it didn't show my Text as having a Custom angle.
So I can't even trust Excel's GUI. (Is this a known problem?)
Yet somehow the chart itself was displaying OK.
What I should have done at the time I was setting those options was take the screen shot immediately, but I had thought I could come back later and do that.
And even if PUP7 was available, but not being updated, would it have new capabilities that Excel gets, like its own native ability like 2013's Labels from range option “Value From Cells”?
Recapping:
1. Is there an add-in that documents all the custom settings that have been done to a chart?
2. If so, will it report them correctly, as the chart displays, or the wrong/default settings that the GUI displays?
where I found the the free standalone Walkenbach "J-Walk Chart Tools" was too out of date to work with modern Excels.
Other threads show that his commercial Power Utility Pack (PUP 7) product is no longer available.
So, Walkenbach's "Chart Report" add-in is no longer available to newcomers.
(It produces a detailled report that documents a chart's many settings, or produces a report that documents all charts.)
In the meanwhile, has anyone written a similar chart documention tool?
I have not found any similar add-in out there, and was attempting to simply use screen shots to record some of my charts customized settings, in Excel 365, but found that what the Options screen showed was wrong.
E.g., Format Axis, Axis Options, Axis Position, showed the radio button for "Between tick marks" selected, when in fact the chart had "On tick marks" actually.
Also, it didn't show my Text as having a Custom angle.
So I can't even trust Excel's GUI. (Is this a known problem?)
Yet somehow the chart itself was displaying OK.
What I should have done at the time I was setting those options was take the screen shot immediately, but I had thought I could come back later and do that.
And even if PUP7 was available, but not being updated, would it have new capabilities that Excel gets, like its own native ability like 2013's Labels from range option “Value From Cells”?
Recapping:
1. Is there an add-in that documents all the custom settings that have been done to a chart?
2. If so, will it report them correctly, as the chart displays, or the wrong/default settings that the GUI displays?