Bar Chart to show cumulative data, day by day

Hi there.

I want to show the amount of records of a SQL table (day by day) in a bar chart, using next script:

SET STATISTICS TIME, IO ON;
SELECT COUNT(*) , CAST([ShiftStartTS] AS date) FROM
MyTable
WHERE shiftstartts BETWEEN DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) AND DATEADD(month, DATEDIFF(month, 0, GETDATE())+1, 0)
GROUP BY CAST([ShiftStartTS] AS date)
ORDER BY 2 ASC

However, it does not work. If I use a power table, it works like this:

Is there a way to set Bar Chart object to show that information?

Thanks in advance.

The date should probably be the first column.

@Rigoberto, a tip: use the </> code formatting button to format code - not bold type.