CODEWITHSUNDEEP
sql-serversql-server-2008charts
Na'te
Na'te

Reputation: 29

SQL server 2008 - Charting problems

I'm trying to create a chart from the below table and ideally would like a line chart with weeks across the bottom, one static sales target line ( Average would work ) and then 4 curve lines for the people. Note: The country and year do not need to be displayed.

Easy to do with a pivot chart in excel, but I am really confused on this one and very new to SQL. Any advise/help would be appreciated.

https://i.sstatic.net/PjuSt.jpg

Upvotes: 0

Views: 30

Answers (1)

simon at rcl
simon at rcl

Reputation: 7344

SQL itself cannot make charts, it can only provide data which other tools can use to make charts from. Using Excel is one solution; other depend on what DBMS you are using and what tools you have available. For example, if you are using SQL Server, then SQL Server Reporting Services (SSRS) makes this easy (once you've set it up).

But with just SQL - no, no charts.

Upvotes: 1

Related Questions