Default Pivot Graph Line Change

[Bill_Biggs]

I have created a pivot graph. The lines are too light and thin to read properly and when I update the data it defaults back to these. Is there a way to chane the default lines and colors?

 

[RoryA]

They're taken from the colour palette bottom row. You can modify them under Tools-Options on the Color tab.
HTH

 

[Bill_Biggs]

the color worked out well. thank you. is there a way to modify the line weights?

 

[RoryA]

Not without them resetting no (short of an upgrade to 2007). You have to use a macro to reset all the formatting if you want anything other than the defaults.

 

[Bill_Biggs]

Thanks again.