Prevent Picture Count from incrementing on "graph to worksheet"
Free Excel tool to easily create Graphviz data visualizations.
Brought to you by:
jjlong150
Menu
▾
▴
#3 Prevent Picture Count from incrementing on "graph to worksheet"
hi.
Is it possible to NOT increment the "Picture" count on each "graph to worksheet", It would be helpful if it remained static (I could then reference it elsewhere in the sheet or externally). Or perhaps a flag on whether it increments?
thanks
I learn something new all the time with this tool. To be honest, I never noticed it was assigning a name to the graph, let alone incrementing a counter.
Your request was an easy change. I added a new configuration setting where you can assign a static name to the picture created from the graph file when the graph is pulled into the workbook. The new setting is on the 'settings' worksheet in the "Graph Options" area. it is the 4th setting with the name "Graph to Worksheet" Picture Name:. If you leave the setting blank then the old picture naming logic will continue. This should ensure backward compatability (if necessary).
A new zip file has been created and uploaded with the revised XSLT template. Sample files and users manual remain unchanged, and will be updated in some future release. The "about..." worksheet should list the version as 3.0.1 with the date 1 January 2019.
Please let me know if this works out for you, or if any additional changes are necessary.
Jeff