First data point in my chart is eliminated when selecting 4 or more items

In my Smartsheet chart on a Dashboard, when I select more than 3 items in the source sheet (not report), the first one is excluded from the data set.
I'm trying to show a column chart for the number of statuses in "Not Started", "In Progress", "On Hold", "Pending Approval", "Complete", "Update", and "Cancelled" statuses. When I select three values in my source data sheet, I can display "Not Started", "In Progress", "On Hold" fine. Once I add those three and any more (such as "Pending Approval"), "Not Started" disappears from my chart and only the 6 remaining values display.
I went as far as recreating the "Feeder Page" and re-linked and re-drew the chart from scratch, with the same result. I also tried in a separate browser (Firefox) and am unable to get it to work.
It is working in a separate, original workspace that I used earlier today. I copied that workspace to a new location and have ensured the chart is pointing to the right file in the right instance. Only other thing I'd mention is that I have 2 text columns ahead of the Status columns in the Feeder Page, but that shouldn't make a difference. I'd appreciate any thoughts on how to fix this.
Answers
-
Rookie mistake. As soon as I posted my comment, I figured out the problem. I had the "Use first column as series labels" option enabled in the chart widget options. Thanks anyway.
-
Hi,
I hope you're well and safe!
Easy to miss! I'm glad you got it working!
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Please support the Community by marking your comment as the accepted answer. It will make it easier for others to find a solution or help to answer!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives