Area chart with overlay line chart

[#1]

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

[MK_QSL · Accepted solution]

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.

[Anonymous]

John

Have tried a Combo Chart ?

Best Regards,     Bill

[MK_QSL]

Combo chart will not give filled area chart !!

[#5]

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