I am trying to create a stacked area chart using the sample data that is attached to this thread.

Please look at the attached NCSP file (rename the extension from GIF to NCSP) for particular details about my configuration. The sample data is attached but the extension has been changed from xlsx to gif. Place the sample data in the same web with a list name of "Work_Percentage_List_Test".

I am trying to stack the areas on top of one another and create a chart that indicates cumulative workload for an individual over time. Instead of stacking, my series end up next to one another on the chart (across the X axis [see example image]).

I also tried sorting the date category by using the expression "=DATETIME(Fields!Start_Date_Enum)" and the graph that showed up from that was even crazier...

There must be a simple fix to this!

Ok, I configured the X Axis as specified in the last post of this thread:

http://forum.nevron.com/shwmessage.aspx?ForumID=13&MessageID=7362

I changed the chart type to XY Scatter Stacked Area and set the X value in the pivot settings as the date (see the last post in the referenced thread). The attached screenshot displays the issue I am now experiencing.

I've attached both the image and an updates NCSP file (change the file extension from GIF to NCSP). This connects to the same data as the example above.