Building a Chart
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...
