I want to be able to create a chart template in excel that has defined formatting but not the colour theme.
So as a User, I woud create my chart using the template but if I change my workbook's colour theme, I want the chart to update with it. Just like the MS Office built-in charts do.
I don't want to use chart styles or layouts as there is no way to define the formatting to my companies style. And none of the defined styles are any good (they don't look good)
can anyone help with this or at least tell me it cannot be done.
So as a User, I woud create my chart using the template but if I change my workbook's colour theme, I want the chart to update with it. Just like the MS Office built-in charts do.
I don't want to use chart styles or layouts as there is no way to define the formatting to my companies style. And none of the defined styles are any good (they don't look good)
can anyone help with this or at least tell me it cannot be done.