Can we please add a graph to this query?

we run this query for each of our managed clients but they prefer the results in a line graph. Any chance we could have that added to this query?

many thanks,
Kathryn

SELECT * FROM (SELECT * FROM MSAReports_WOByPriority WHERE NewPriority LIKE 'Created %' AND Account LIKE 'XXX%') as BaseQuery
PIVOT (COUNT(RequestID) for JobCreated In ([01-2016],[02-2016],[03-2016],[04-2016],[05-2016],[06-2016],[07-2016],[08-2016],[09-2016],[10-2016],[11-2016],[12-2016])) as TotalPerMonth
UNION
SELECT * FROM (SELECT * FROM MSAReports_WOByPriority WHERE NewPriority LIKE 'Resolved %' AND Account LIKE 'XXXX%') as BaseQuery
PIVOT (COUNT(RequestID) for JobCreated In ([01-2016],[02-2016],[03-2016],[04-2016],[05-2016],[06-2016],[07-2016],[08-2016],[09-2016],[10-2016],[11-2016],[12-2016])) as TotalPerMonth
ORDER BY 1, 2