Excel Pivot Chart like output

EricO

Is there any way to create a chart with multiple row/column group by functions like in Excel using the Interactive Chart tool.  I want to show year over year results of responses received to a survey by date. as in the chart below.

My Source data looks like this:

Date	Count
1/1/2015	37
1/2/2015	28
1/3/2015	47
1/4/2015	4
11/30/2015	1
12/1/2015	1
12/13/2015	2
12/14/2015	7
12/15/2015	3
12/17/2015	2
12/18/2015	1
12/20/2015	146
12/21/2015	52

EricO

Hi Angelos,

Thanks for your help.  This was more complicated than just sorting the data properly.  The underlying issue was that each "Campaign" or series as they are called in Excel needed to have all the same Range values (Date) present in order for the chart tool not to go crazy. In your examples, you used data points on all the same day-of-month, even if you skipped some days.  However, in my actual data, not every series had the same calendar days.  For example in 2015 there might have been a Nov 15, but in 2016-2020, there might not have been.  Once I created a Cartesian table of dates, so that every series has the same number of range values, the chart sorted itself out.  There is probably an easier way to do this, but it was what I came up with base on my limited experience with the tool.  Thanks again for the help.

 vs. 

example.yxmd

DateInCampagin.yxmc