Format Data Series in Pivot Chart
 

Can anyone help me with the code that I would need to select a specific
data series (or multiple series), in a pivot chart and change the color
(i.e, black) and weight?

Currently, the series format changes back to the default settings each
time you modify the view.

thanks


--
tobriant
------------------------------------------------------------------------
tobriant's Profile: http://www.excelforum.com/member.php...o&userid=25155
View this thread: http://www.excelforum.com/showthread...hreadid=476873

Format Data Series in Pivot Chart
 

If you turn on the macro record as you perform the steps manually,
you'll get most of the code that you need. Once you have that, if you
need help with modifying the code, you could post the specific steps
where you're having problems.

tobriant wrote:
Can anyone help me with the code that I would need to select a specific
data series (or multiple series), in a pivot chart and change the color
(i.e, black) and weight?

Currently, the series format changes back to the default settings each
time you modify the view.

thanks




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html