Would like the blue and red to have a different label.
Hi @Jessica Howell
For sure you can.
Just edit the dashboard, then edit the widget and go to the series options (last one on the right panel). You'll be able to change colors for every entry :)
Hope it helped!
Sorry, not the color, the name...
@David Joyeuse forgot to tag.
What type of chart are you using? The labels are drawn from the Column that the data is stored in. If you are comparing two columns of data together, then these labels would be the Column Names:
To change this, you would just need to update the Column Name in the sheet.
In other types of charts (say if you only have one data to compare, like in a Pie Chart), then one of the columns contains the labels and the other column contains the numerical data:
If you're not seeing the right column or data as the legend, try clicking the button that says "Switch Rows/Columns".
Let me know if you have any other questions! It would be helpful to see a screen capture of your full chart and another one of your sheet (or perhaps a pic like mine above with both showing), but please block out any sensitive data.
I created a master numeric data sheet for charting, so the column names aren't universal across the sheet
Thank you :)
Are you looking to map the YTD Q1 for 2020 & 2021 side by side together in a graph? If so, you would need to change the column names to reflect those quarters. I understand this means that other graphs being pulled from this sheet may have incorrect labels though, so there are a few different solutions to this.
1 . You could either create a new sheet that is solely for this one chart so that your column names reflect the correct data. (Or move that data over to the right and spread your sheet out horizontally so that this chart has unique column names).
2 . You could hide the legend in the chart itself and create your own legend using the text widget on the dashboard to outline what the blue and red represent.
Does that make sense?
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I created a timesheet and a form to go along with it. When someone uses the form and flags that someone has called off, I want the flag to return zeros in the ST Hrs, OT Hrs, and DT Hrs cells. Using AI to generate the formula below, it returns a Circular Reference error when the formula is placed in the ST Hrs cell.
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
©2024. All Rights Reserved Smartsheet Inc.