software

Hi,

How can I keep a personal format in a dynamic chart, when I updated
it?

All the time, it returns to the original format.

Thanks

Renato8--
Renato8
------------------------------------------------------------------------
Renato8's Profile: www.excelforum.com/member.php...oamp;userid=30604
View this thread: www.excelforum.com/showthread...hreadid=503296By Dynamic Chart, do you mean Pivot Chart? Pivot Charts are notorious about
removing any formatting when they are updated. You could make a regular
chart from a pivot table's data. Select a blank cell that's not touching the
pivot table, start the chart wizard, and in step 2 of the wizard, use the
Series tab to define the series in the chart. Such a chart will not lose
formatting, but if the shape of the pivot table changes, the chart will not
reflect the new configuration.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Renato8quot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; How can I keep a personal format in a dynamic chart, when I updated
gt; it?
gt;
gt; All the time, it returns to the original format.
gt;
gt; Thanks
gt;
gt; Renato8
gt;
gt;
gt; --
gt; Renato8