Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Chart Format (2003 and 2007)

    Would it be possible to change the last column on the far right to another color and leave the columns to the left blue?
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Pivot Chart Format (2003 and 2007)

    Hi Stans

    Click on the bar until all of the bars are highlighted and click on it again. The bar will then have each corner highlighted. Right hand click it and select format data point, choose your colour.
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Chart Format (2003 and 2007)

    Excel will reset the colors each time you update the pivot table/chart, so you'd have to write a macro that formats the chart when it is updated.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Chart Format (2003 and 2007)

    Perfect

    That makes my "Grand Total Column" really stand out.

    Thanks

Posting Permissions

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