Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I need to generate a an area chart for current forecast with a line chatr representing the previous year forecast. We would normally use Excel to do this, setting current forecast as the Area and the last one as the Line - no problem in Excel. To do this in QV I've had to create two charts, an area chart (line with fill) and a line chart - I then overlay these two charts. My problem arises in that the Y-ases of the two charts need to be identical. I would like to set the axis of the line chart equal to that of the Area chart. Can anyone advise how I can achieve this
Many Thanks
John
Go to Axis...
Under Scale...
Set Static Min as
=if(Min(Aggr(SUM(LYForecast),Month))<Min(Aggr(SUM(CYForecast),Month)),
Min(Aggr(SUM(LYForecast),Month)),
Min(Aggr(SUM(CYForecast),Month))
)
and Static Max as
=if(MAX(Aggr(SUM(LYForecast),Month))>MAX(Aggr(SUM(CYForecast),Month)),
MAX(Aggr(SUM(LYForecast),Month)),
MAX(Aggr(SUM(CYForecast),Month))
)
For both charts...
Please check enclosed sample file..
Dont forget to keep one chart layout at top/normal and another as bottom.
Go to Axis...
Under Scale...
Set Static Min as
=if(Min(Aggr(SUM(LYForecast),Month))<Min(Aggr(SUM(CYForecast),Month)),
Min(Aggr(SUM(LYForecast),Month)),
Min(Aggr(SUM(CYForecast),Month))
)
and Static Max as
=if(MAX(Aggr(SUM(LYForecast),Month))>MAX(Aggr(SUM(CYForecast),Month)),
MAX(Aggr(SUM(LYForecast),Month)),
MAX(Aggr(SUM(CYForecast),Month))
)
For both charts...
Please check enclosed sample file..
Dont forget to keep one chart layout at top/normal and another as bottom.
John
Have tried a Combo Chart ?
Best Regards, Bill
Combo chart will not give filled area chart !!
Hi Misha,
That worked perfectly Very elegant
I hear that QlikTech are planning to improve their charting in the next version.. look forward to that