Creating a graph for weekly view

[#1]

I have a table with the entity in one column, and then 53 columns for each week.

How can I create a chart with the weeks along the x-axis and the different entities in the graph???

Is it also possible to get these weeks in a list box so they can be selected? even though they are different columns?

Thanks for any help in advance.

[Josh_Good]

You should load the data using a cross table.  This will transform the data so it is three columns, your first entity, the week and the data.  Here is a video that shows how to use the cross table function.

http://www.youtube.com/watch?v=qHu45iWamL8

[jagan]

Hi,

Use Crosstable() to convert week columns to rows and you just use Week column as dimension in the chart.  Refer CrossTable() example in Help file.

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

Close this discussion if you find the solution.

Regards,

Jagan.