how to keep pattern color after renewal of data

[ghislain]

Hello,
I have a sheet with a graph representing the sales figures over th
months from the last years. I modify the color and the thickness of th
line in the linechart. ( ex: budget = green )
Everytime I renew the data ( = query to a database ) the properties o
the lines are gone.
Any info on how to keep the properties?
Thanks in advanc

 

[Jon Peltier]

This happens with pivot charts. You can record a macro to restore formatting, or
save a custom chart type to reapply. For more information see the Charting FAQ:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon026

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