Bar Graph not including both identifiers

Meredith Zamperini
edited 01/12/23 in Smartsheet Basics

Please see attached graph picture. Right now the key is only showing total sites and I need it to differentiate the Total sites and Live sites and they need to be different colors but when I go into series setting it only gives me one color option?


Answers

  • Kiela
    Kiela ✭✭✭✭

    Kia ora,

    I used the switch rows in the edit bar and this changes the options


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Meredith Zamperini

    Currently Bar Charts have one set colour for all the bars. If you use multi-bar charts then you can select different colours.

    Here's an example showing how I formatted the source data:


    I agree that switching rows/columns in your chart should help - this will put "Total Sites" and "Live Sites" as the Legend for the chart, so you can select different colours.

    If this hasn't helped, it would be useful to see how your source data is formatted in the sheet so we can help further.

    Cheers,

    Genevieve