Stacked Line Chart

[Anonymous]

Hi..Can anybody please help how to plot a stacked area chart by converting the existing line graphs.

I need to plot a demand and supply stacked area chart..Currently i have 3 line charts as attached. I need to have these as stacked area charts. Can anybody please share the steps how to do this in QV?

Thanks

Sanjyot

[bwisealiahmad]

Hi Sanjoy,

Have look under "Style" and pick the number two from the left bottom. Originally this stacks them on top of each other, but if you take Expr1-Expr2 then with that logic it should help.

See attached.

[tresesco]

Goto the Style tab of the chart -> Choose one style from the Look option(last two).

[avinashelite]

In the expression tab of chart properties you can use the >Display Option> next to Line > you can chose the smooth and value on the data points . This will get a chart according to your requirement

[Anonymous]

!Thanks..I am getting 2 X axis when I change the style but I need only one X axis to show that the demand and supply start from the same x axis.

[tresesco]

Not clear. Could you share a sample qvw?

[mohammadkhatimi]

Can you share a sample qvw?

[Anonymous]

I have 2 expression as below

1) Supply - ceil(sum({<[Project Name]=,[Project Delivery Status]=>}Supply_HCM))

2) Active Demand - ceil(sum(if(PlanType='Demand' and ([Project Delivery Status] = 'Initiated' or [Project Delivery Status] = 'In Progress') ,Demand_HCM)))

3) Pipeline Demand - ceil(sum(if([Project Delivery Status]='On Hold' or [Project Delivery Status] = 'Not Started',Demand_HCM)))

Please elaborate what needs to done in the expression tab with the above given expressions.. I have selected the 2nd option under Style from the left bottom.

[Anonymous]

Added qv file and the base files

[bwisealiahmad]

See attached file for what I meant. Does that make sense? I am not sure if I fully understand, but look at it. You can also play around with the transparancy of the colors.

Bets,

AA !