How do I get dates on my widget's horizontal axis?
My dashboard has a widget to show a certain statistic. The data comes from multi-column sheet, 4th column as you can see below.
But I can't see to get the date to populate the horizontal access.
How do I do that?
Answers
-
Hi @Hans E ,
Open your chart widget for edit. Under "Columns Included" there are 3 toggles. Select use column names as category labels and use first column as series labels. Does that get the result you want?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Unfortunately no. The "Use first column as series labels" is grayed out.
-
I have a similar issue. I have created a report that summarizes the level of effort for each assigned to. Although I get a total effort and count of items for each assigned to, I do not know how to get a label for each assigned to.
-
I was able to resolve my above issue. I was trying to chart data with an incorrect report. Once I had created the correct report format the chart worked GREAT!
Specifically, the REPORT I created had
Columns Sheet Name Assigned To, SEff(Small Effort), MEff(Medium), and LEff(Large)
Filter Assigned To is not blank
Group Assigned To
Summarize SEff, Meff, LEff
Sort Assigned To Ascending
The CHART variables
Columns All columns
USE column Names as Category Labels
Use First Column as Series labels
Chart Type Column
Title Effort by Assigned To
Horizonal Axis Assigned To
Vertical Axis Effort in Hours
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives