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?
I used the switch rows in the edit bar and this changes the options
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.
I have data in Excel that I need to import on a weekly basis into Smartsheet (lets say columns A-F) I would like to have columns (lets say G-H) with formulas. How do I import data each week replacing the previous week's data (only columns A-F) without overwriting the formulas? Is it possible to do this via Datashuttle or…
We had a Latest Comment column but the Column Type wasn't accurate. Showing as a Text / Number type. I tried to resolve this and I get the error "There is already a Latest Comment column in the sheet". To try to resolve, I created another column and deleted the original. However this still hasn't fixed the issue. There are…
Hi everyone, my colleagues and I are new joiners to smart sheet, we all have pro plan licenses, but when I share a sheet with them with Admin access for each and every one of them they still don't see the Filter CHOICES I added in the Task Bar (to the right of the dropdown for changing the view), any idea why that is? I…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.