What element of the chart is losing its formatting?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


tomjohns wrote:

Hi,

I am making a custom chart and hits the problem mentioned in the
article from Peltier:
http://peltiertech.com/Excel/ChartsH...stomTypes.html

It says: "Another problem with a custom chart type, or any chart with
customized formatting. If a chart element with custom formatting is
removed from the chart, then added again, the custom formatting is
lost, and the element takes on the default formatting for that element
in the default chart."

Is there a smart way to solve this problem? Could the best thing to do
be some VBA-coding and to keep track on the change-event from the chart
and then reapply the custom chart type?