4 Replies Latest reply: Nov 23, 2013 8:41 AM by John Murray RSS

    Area chart with overlay line chart

    John Murray

      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