+ Reply to Thread
Results 1 to 3 of 3

Assign specific colours to multiple Pivot Chart Data Series

  1. #1
    Registered User
    Join Date
    02-12-2021
    Location
    England
    MS-Off Ver
    Microsoft 365 Version 2012
    Posts
    32

    Assign specific colours to multiple Pivot Chart Data Series

    Hi All, hoping someone can help please!

    I have created Dashboards that contains approx. 40+ pivot chart across multiple tabs within a single excel worksheet.

    All the pivot table and data sources are contained in the same excel worksheet and the data sources are within a 'Dynamic' tables.

    Note: As this file is so large, complicated and confidential i cannot post an example, so apologies.

    The dashboard contains x3 types of graphs (Pie, Column and Bar Charts).

    When i replace and/or update the data source info and select 'Refresh All', the graphs are updated, FAB. However, the assigned colours i manually nominated revert back to excel pallet of some description. Having to manually alter these across so many graphs each month is not practical especially as multiple people will be updating this worksheet and it need to be user friendly.

    The dashboards have slicers (Mainly Year and Months), as primarily monthly data will be reviewing across numerous business functions.

    Across all the graphs, i need the colours i have assigned manually to the month series (Jan to Dec) to be applied automatically.

    I am not advanced enough with VBA code but have looked at examples and cant find one that works. I have also tried to save a template, however this is specific to graph type and is also not suitable as different titles etc. are unique to several graphs.

    If you require any further info please ask, any help would be appreciated.

    Kind Regards

  2. #2
    Forum Contributor
    Join Date
    01-17-2012
    Location
    Canada
    MS-Off Ver
    Excel 365
    Posts
    221

    Re: Assign specific colours to multiple Pivot Chart Data Series

    Hi Redders,

    Have you tried unselecting the checkboxes (see attached) and try the refresh again. I use this method to preserve chart formatting and it works well.
    Attached Images Attached Images
    Regards,

    jeversf

  3. #3
    Registered User
    Join Date
    02-12-2021
    Location
    England
    MS-Off Ver
    Microsoft 365 Version 2012
    Posts
    32

    Re: Assign specific colours to multiple Pivot Chart Data Series

    Thanks jeversf this seems to be working. Only time will tell. Much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pie Chart slice colours from data series
    By J.McQ in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 09-12-2019, 08:17 AM
  2. Fix colours of Power Pivot Pie Chart slices based on data category name
    By dp39darren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2019, 06:17 AM
  3. Pivot Combo chart - retain chart type for specific data series
    By meileetan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-21-2019, 03:48 AM
  4. Maintaining consistent colours for series in Pivot Charts
    By tanababa in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-15-2018, 05:07 AM
  5. Replies: 2
    Last Post: 02-19-2017, 07:52 PM
  6. Replies: 0
    Last Post: 09-27-2014, 02:09 PM
  7. how to get multiple series with pivot chart
    By superchew in forum Access Tables & Databases
    Replies: 1
    Last Post: 08-07-2014, 03:15 PM

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