Is there a way to change each row (separately) for a bar chart? when you change the colors, it changes every bar; I would love to change each bar, as a different color.
It depends on how you have your data set up for the chart. Try checking the box in the chart builder to switch rows and columns. If that doesn't work, try switching up the layout of the source data.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
@Paul Newcome .. Interesting.. I've switched the rows/columns that doesn't work; I am wondering how to switch up the layout of the source data / report; obviously, I am doing it wrong. 🤔
@Susan Swisher What about using a different type of Chart? For example a Pie or Donut chart? These types of charts allow for each individual number to be a different colour.
Too many items in the data; and it lends itself to a Bar Chart, verses Pie / Donut chart.
If @Genevieve P's solution of using a different type of chart does not work for you, can you provide a screenshot of your current source data with confidential data removed, blocked, or replaced with "dummy data" as needed?
@Paul Newcome The Source-Data (picture) is an image of the Source Data Report that I generated from an the "Sheet Summary" data from an existing sheet.
I keep trying to upload a file; and it isn't working. Not sure what is going on.
@Paul Newcome Now I semi-figured it out... I was able to change the bar colors, like I wanted (as a group of colors); however, I lose the names, because I switched the rows/columns (as you suggested); obviously my source data can be fixed (I hope).
I don't want to use a legend, because I would have a legend for each bar; and I want them grouped by the "compound" (24360, 00012, OX40, GITR, ARG)
What if you were to put each of them in their own row down a set of two columns?
24360: Accrual Complete...........3
24360: In Start-Up.......................0
If you are using separate columns for each, have you tried checking this box?
I thought about that.. however, the columns/data is being pulled from the Sheet Summary and can't be changed; unless I re-type / re-do it.
I did check that.. when I make the switch of columns and rows, it picks up the number "3" and that number "3" is coming from the 1st column (odd)
I did find that, @Genevieve P suggestion (using PIE) allows me to show it "smoother" however, i'd have to use the legend and then "hover" over the items, to show the different categories, in each category.
In your Edit Chart Widget screenshot... What happens if you uncheck the box to use the first column as labels?
To restructure the data, you should be able to click and drag the formulas. If you hover over the border of a cell, the cursor should change to the plus arrows. You can then click and drag that cell to wherever within the sheet. Doing this will maintain the formula's reference, and any other formula in the sheet referencing that cell specifically will also update to reflect the cell's new location.
I can't restructure the data.... because it comes from a Summary Sheet
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.