Format Series in Pivot Chart
Can anyone help me with the code that I would need to select a specifi data series (or multiple series), in a pivot chart and change the colo (i.e, black) and weight? Currently, the series format changes back to the default settings eac time you modify the view. thank -- tobrian ----------------------------------------------------------------------- tobriant's Profile: http://www.excelforum.com/member.php...fo&userid=2515 View this thread: http://www.excelforum.com/showthread.php?threadid=47695 |
Format Series in Pivot Chart
As answered at your earlier post:
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 |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com