I'm having trouble creating the chart that I want to make. For some reason, the "switch rows/columns" function is not selectable. Why is this and is there a way to fix it?
Are you able to provide a screenshot of the data?
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Hi Paul, here's a screenshot of the worksheet. I'm trying to make a chart that has PMRC Time along the X-axis. I'd like it to be a stacked column chart because each column could have more than one value. I annotated the image with red text to illustrate what I mean. Although most of the cells are empty now, I would like to have PMRC ID# included in the chart as well.
I'm probably not doing a great job of explaining the desired chart so I've also attached a sketch of what I would like it to look like. Thank you for any suggestions!
Are you including the ID# column when you are selecting the data for your chart?
Yes indeed. Here's an image:
What happens if you check the box to use column names as labels?
Thanks for your help with this but I believe I found the problem. Someone had changed the column type from Text/Number to Dropdown for the PMRC Time (Hrs) columns. I just duplicated the worksheet and ran a test. Now with the columns changed back to Text/Number, I can create the recreate the chart we initially had.
Thanks again for your help troubleshooting
Excellent! Glad you were able to get it working.
Please don't forget to flag your solution as "helpful". This lets others searching for a similar solution know that one may be found here.
Would it be beneficial to include an option that enables a forms user to complete a form and then initiate a new submission for the same form. Currently, users can navigate back using the browser's back button, but they are required to overwrite all the previous answers, which can be cumbersome.
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…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.