UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Bar Chart Color Formatting Not Sticking When Filtered, Office 2013    
 
   
momcaro
post May 16 2018, 02:08 PM
Post#1



Posts: 297
Joined: 25-March 11
From: Wish I was in Colorado


Hello,
I am using a stacked bar chart to make a Gantt chart (https://www.officetimeline.com/gantt-chart-excel). It works great, but I would like to color each bar with a "team" color, depending on who the tasks belong to. I can do all this manually, a bit tedious but no problem (I have ~130 tasks and 6 colors). Here is the rub: the formatting is not sticking; as soon as I filter/unfilter my data, the colors on the bars go haywire. I have looked online and found no solution. Unchecking the "properties follow chart data point for current workbook" in the advanced options seems to have helped a lot of people, but not me...
Thoughts? Am I doomed to not being able to filter?
Thanks!
Caroline

--------------------
Caroline
Mooing Sheep
Go to the top of the page
 
momcaro
post May 17 2018, 10:52 AM
Post#2



Posts: 297
Joined: 25-March 11
From: Wish I was in Colorado


Well I finally figured a workaround, so I figured I'd share for posterity. I ended up using this idea: https://peltiertech.com/conditional-formatt...f-excel-charts/
I have a stacked bars chart, so it didn't work exactly the same, I had to add a series for each color, but so far, so good with filtering and adding numbers to my series.
This post has been edited by momcaro: May 17 2018, 10:53 AM

--------------------
Caroline
Mooing Sheep
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd May 2018 - 01:24 AM