Line chart help and data modelling help

[Anonymous]

Hello experts i have a modelling question or creating a chart question to help me visualize my better in a better way.

This is how the table looks now.

Header 1	Header 2	Header 3	Header 4
Campus	January customers	February customers	March customers
East	8	12	34
South	4	3	6

End product:

I want to create a line chart by month, by campus to show a trending line for the months. That means i want to have two lines that are connected, one will show the East zone and the other one will show a south zone.

Thank you experts for all the help.

[sergio0592]

You can use CrossTable prefix with :

New_table:

Crosstable (Month, Expression) LOAD Campus, [January customers],[February customers],[March customers]

resident Table1;

DROP Table Table1;

The Crosstable Load

[Digvijay_Singh · Accepted solution]

Like this may be -

[Anonymous]

yes Thats the way i want it to look like.

[Digvijay_Singh]

Have you got what you needed in the file attached?