Building a Chart

juancap94951

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

 

 

juancap94951

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...