Bar Graph not including both identifiers

Meredith Zamperini

StorePoint 3.PNG

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?

StorePoint 4.PNG

Kiela

Kia ora,

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

SS.PNG

Genevieve P.

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