2 Replies Latest reply on Jul 25, 2012 10:56 AM by Matt Dundas

    Combination area & line charts

    Matt Dundas

      Hello,

      I have an Area chart that is perfect except i would like to overlay a curve showing the total.

      ( usually the top of an area chart IS the total except when some of the values are negative, like in the attached example.

      Notice how of the top of the chart is actually a sum of positive values ).

       

      To get a Total i tried using a dual combination chart, but that doesn't work well with Area Charts.

      So then i tried adding a Reference Line but i couldn't get that to work either.  ( When i do the "Sum" it puts a straight horizontal line at 13,000,000,000 for some reason ).

       

      Any guidance on this?

      Has anyone done a combination Area & line chart?

       

      Thanks!

      -md