Line Chart

[#1]

I am trying to create a line chart out of the attached data.  Really struggling due to the orientation of my excel file. 

This should be easy just drawing a blank.  Ideas?

Thanks

~Norman Rea

[sunny_talwar]

Script:

Table:

CrossTable (FiscalYear, Value)

LOAD * Inline [

Project, FY2015, FY2016, FY2017

Proj1, 10, 40, 30

Proj2, 20, 20, 10,

Proj3, 20, 30, 40

];

FinalTable:

LOAD *,

  Right(FiscalYear, 4) as Year

Resident Table;

DROP Table Table;

[#3]

How would I do this with and excel file?

[sunny_talwar]

This:

Table:

CrossTable (FiscalYear, Value)

LOAD Project,

    FY2015,

    FY2016,

    FY2017

FROM

Community_219531.xlsx

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD *,

  Right(FiscalYear, 4) as Year

Resident Table;

DROP Table Table;

[#5]

What are your settings for you chart?

[sunny_talwar]

Two dimensions

Year and Project

One expression

=Sum(Value)

[#7]

Hi Sunny,

I'm new so for the sake of simplicity, can you tell me why the Right function is being used here?

Thanks,

[Anil_Babu_Samineni]

Right function indicates -- Year like 4 ( Why 4 Is here - YYYY, if you take 3 /2 /1 That is not good to see for users...)

That is the reason he mentioned RIGHT

[Anil_Babu_Samineni]

No settings are there. Just he created Line chart with Calendar object ...