If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

pivot cahrt Formatting issues from one workbook to another

Thread starter iansberg
Start date Jul 28, 2015
Tags

excel 2010 formatting pivot chart

iansberg

New Member

Jul 28, 2015

I have a bunch of pivot charts in a few different workbooks. I cannot get the legend to have the same formatting across workbooks. I have a bunch of series in the legend on a varying color scale. B is always red in workbook 1 legends. B is not and will not turn to red in workbook 2 legends. I tried to copy and paste formatting but it didn't change legend colors. Also all the series are the same names in all the legends across workbooks(but not from same source). I have many series in my legend and cannot do a manual color change. Anyone know whats up?

thanks!

Excel 2010.