Which Chart to Use to Create Excel Like Table

[#1]

Hi All

I could do with a little help as to which chart to use:

I need to create the equivalent of and excel table

1 Axis = Names (down the left)

1 Axis = Starting date of Each Week (across the top)

Intersection = sum(timespent)

I have tried the pivot table but its not what i am looking for.

Any other suggestions?

Thanks

JP

[Miguel_Angel_Baeyens · Accepted solution]

Hi JP,

Pivot table should do if you pivot the dimension corresponding to the Starting date of each week to the top, by holding the mouse in the dimension column until you see a big blue arrow and dragging it to the top of the chart, when the arrow points to the left horizontally.

Did you try that?

Miguel

[#3]

Hi Miguel

Thanks a mil, exactly what I was looking for. I didn't know you could do that, so I was stuck with the everything in 1 axis.

Best

JP