none
Retain formatting in Excel Pivot Chart RRS feed

  • Question

  • Hi everyone

    I have an Excel Pivot table and chart. I want to change the lines in the pivot chart so that they are thicker and different colors. My problem is that whenever I alter the pivot chart to show different results the formatting returns to the original format.

    Is there any VBA I could use to prevent this from happening?

    Thanks in advance.

    BO

    Wednesday, May 16, 2012 12:05 PM

Answers

  • Record a macro where you select the chart, refresh it, then format all the lines the way you want. Then use that code in the PivotTableUpdate event.


    HTH, Bernie

    • Marked as answer by ByronOne Wednesday, May 16, 2012 1:33 PM
    Wednesday, May 16, 2012 1:28 PM

All replies

  • Record a macro where you select the chart, refresh it, then format all the lines the way you want. Then use that code in the PivotTableUpdate event.


    HTH, Bernie

    • Marked as answer by ByronOne Wednesday, May 16, 2012 1:33 PM
    Wednesday, May 16, 2012 1:28 PM
  • Cheers Bernie

    Appreciated as always!

    Wednesday, May 16, 2012 1:33 PM