Building a Chart

juancap94951 ✭✭
edited 12/09/19 in Smartsheet Basics

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.





ss pivot.PNG