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!

Bob,
The problem is with the data you are passing to the chart. Because you have Category grouping by Date (start date) and Series grouping by Project, this results in a chart with multiple empty data points. This is why the Stacked Area chart looks incorrect. In other words, the Area series are not stacked because you don’t have data for the different projects for the same Date.

To get a better understanding of this, simply switch the chart type to Bar and/or Line (sub type Stacked). This will provide a better view of the result that is coming from your data.

Best Regards,
Nevron Support Team