By following tutorial :
http://www.aspforums.net/Threads/209868/How-to-dispaly-Multi-Line-Chart-using-jQuery-Chart-plugin-in-ASPNet/
I provided a chart in my page , but there is a problem
I would like to show last 7 inserted records in my chart from left to right.
I use ID for “ORDER BY” but as number of ID started from 1 to .....
I could not show data left to right and the data shows in my chart from right to left,
The Query :
SELECT TOP 7 SUBSTRING(DATENAME(MONTH,[Time]),0,4)+CONVERT(VARCHAR(10),DATEPART(DAY,[Time])) Day,Total FROM [PL-PK] ORDER BY Id DESC
Attach of my table :
https://i.imgsafe.org/3934716103.jpg
Attach of chart :
https://i.imgsafe.org/3933419286.jpg
I think a sub query is needed, I tried something but without successful.
Your help would be appreciated