+ Reply to Thread
Results 1 to 2 of 2

Preserve formatting in Pivot Chart

  1. #1
    Craig
    Guest

    Preserve formatting in Pivot Chart

    I have a Pivot Chart with 2 sets of information. Each set is charted
    differently (one is a column chart, the other a line chart). WHen I refresh
    both sets default to column chart. Is there a way to preserve the Pivot
    Chart formatting through refresh?

  2. #2
    Andy Pope
    Guest

    Re: Preserve formatting in Pivot Chart

    Hi,

    This is a know problem.

    Changing a PivotChart removes series formatting in Excel
    http://support.microsoft.com/default...;EN-US;Q215904

    Cheers
    Andy

    Craig wrote:
    > I have a Pivot Chart with 2 sets of information. Each set is charted
    > differently (one is a column chart, the other a line chart). WHen I refresh
    > both sets default to column chart. Is there a way to preserve the Pivot
    > Chart formatting through refresh?


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1