Hi:
I would like to set the default Excel 2013 chart weight to 1pt for all and every line chart our team creates or edits ....
We have a line chart crtx template file with lots of series which do the trick when a chart is initially created.
But when a user adds an additional column of data to the sheet and extends the series selection to add the series to the existing chart the line that is added reverts to 2.25pt.
Can I globally set the default line weight within the xltx template so that all line weights are 1pt, not 2.25pt?
The line.crt we use works fine when initially selected and created, its when extra series are added later that the line is added with the incorrect weight.
We could create a vba "standardise" button that would apply the line weight to all charts when the editing is finished, but why on earth can't we set the value as we want it to start with!!
Excel has to pick up this default 2.25 value from somewhere (xml, theme?) but where?
Bookmarks