title: Dundas / Microsoft charting stacked area chart multiple series with mixture of positive and negatives
body: <p>I would like to create a stacked area chart which contains multiple series, however we would like all the positive values to be stacked positively (above the X axis) and all the negative values to be stacked negatively (below the X axis).</p>
  
  <p>The stacked area series doesn't appear to be creating the desired effect.  Its a little difficult to explain but if there are 4 series and series 1, 2 had a positive data point these would stack upward away from the x axis.  If series 3 had a negative data point the series would be rendered from the cumulative peak of 1 and 2 down toward the x axis, finally the 4 series would be render from the cumulative of the 1, 2, and 3 series. </p>
  
  <p>I'm using (legacy) Dundas charts, the version just before Microsoft bought the IP and created the Microsoft Charting Visualisation in .NET.  A switch to us this instead could be on the cards so if the ideas involve this too that would be great.</p>
  
  <p>Can anyone please suggest some ideas or ways to achieve this using either technologies.  </p>
  
  <p>Are we using the wrong type of chart perhaps?</p>
  
  <p>Thanks,</p>
  
  <p>Philip</p>