Building a Chart
![juancap94951](https://us.v-cdn.net/6031209/uploads/drupal_profile/files/2019-07/b7/cd/nb7cd0d7525e4176446753682e2b33d3c.jpg)
Hi everyone... i'm having some issues building a chart...don't know if what i want to do is not possible or i0m doing it the wrong way....
here it goes...
I have a pivot table, where i'm making the summary of the hours spent by members of a team by project and by the month.
I'm trying to build a chart where my X axis have the number of the month, and using a stack column chart (i'm using this since a person can be working in different projects) i want to see the amount of hours per project of a particular person.
The problem so far is that i could not set the month value as X axis...
Appreciate if you can please let me know what i'm i doing wrong.
Thanks
Comments
-
Also... if its possible... can the chart be dynamic, i mean... if a new row is added into the table, the range of the data can be automatically updated too...
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives