Skip to main content
Question

Color coding chart inconsistencies

  • March 27, 2023
  • 0 replies
  • 152 views

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
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+16
    • MikeTamoush
    • Quickbase Alumni
    • March 29, 2023

    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
    ------------------------------

    Terms & ConditionsAccessibility statement