How to dispaly Multi Line Chart using jQuery Chart plugin in ASP.Net

Use top 7 to get only 7 record.Your query should be like

SELECT TOP 7 SUBSTRING(DATENAME(MONTH,[Time]),0,4)+CONVERT(VARCHAR(10),DATEPART(DAY,[Time])) Day FROM PL_PK
SELECT TOP 7 SUBSTRING(DATENAME(MONTH,[Time]),0,4)+CONVERT(VARCHAR(10),DATEPART(DAY,[Time])) Day,Total FROM PL_PK
SELECT TOP 7 SUBSTRING(DATENAME(MONTH,[Time]),0,4)+CONVERT(VARCHAR(10),DATEPART(DAY,[Time])) Day,[Plan] FROM PL_PK

For height and width remove "%".

ctx.canvas.height = 50;
ctx.canvas.width = 100;