+ Reply to Thread
Results 1 to 1 of 1

Pivot Chart Sub Total Category. Vary Colors

  1. #1
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    494

    Pivot Chart Sub Total Category. Vary Colors

    As can be seen on the attached image, i have expanded the Pivot Table down to view a more broken down view of the data.

    With the current view, is there VBA that i can add to make a more visual difference between the 1200 data and the 1050 data, so the 1200 or 1050 columns vary in color?

    If i change the 'Vary Colors by Point', each column is a different color, where i want all the 1200 section columns one color, and the 1050 section another color.

    Is this possible?
    Attached Images Attached Images
    Last edited by coreytroy; 03-27-2013 at 07:17 AM. Reason: Spelling error

+ 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