Color coding chart inconsistencies

Question

Hello, I am wondering if this is not possible: I set up a timeline report with custom colors for 10 different groups. Now I have a request to create stacked bar charts for these same groups using the same custom colors. When I try this, I get the message 'Legend: Colors will be assigned automatically. Either no records match the filter right now, or a report formula is chosen as the series.' The hex codes display as the legend on the chart, so if the charts are on the same dashboard, the colors are meaningless. Would a formula rich text field get around this, or is colorization on a stacked bar chart not customizable?

------------------------------
Lisa Sell
------------------------------

miketamoush · Answer

Frustratingly, customization is not totally possible. This drives me nuts but here is the deal:
If your bar chart (or pie chart) already includes all the options and the options will be there forever, then QB will auto assign colors to each bar/pie slice, which you can then customize and change.
Here is the rub - if any of the bars or pie slices dissapear (maybe you have a filter and sometimes the bar exists and sometimes it doesn't), every time it comes back it will be auto assigned a color.
I found a user feedback on this and upvoted it as much as possible because its very annoying. I hope they listen!
------------------------------Mike Tamoush------------------------------

lisasell1 · Answer

Thank you, Mike,
This was what I suspected - you have saved me a lot of time I would have spent trying to solve this. This sort of thing makes it difficult to 'sell' my team on the advantages of reporting in QB. I will add my vote to the user feedback and hope for some future update.------------------------------Lisa Sell------------------------------

Forum Discussion

Color coding chart inconsistencies