Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Refreshing pivot charts

    When I refresh my pivot-based charts, the formatting of the data series restores to the oiginal default setting from when the chart was created. I cannot save the formatting changes that I've made. I've looked and looked and I'm stumped on this simple thing. What am I doing wrong?!?!?!?!?!
    thanks
    christine

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hi Christine - Which version of Excel is being used?

    This thread may offer some clues.....
    Pivot-chart-formatting-options-lost-upon-data-refresh-(Excel-2002-SP3)

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you for the update. I'm glad to know that this is a bug and will be fixed when I move from 03 to 07!
    thanks
    christine

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •