Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 A Simple Way to Make A Graph/Chart?

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2009-10-28 : 10:02:27
hi experts,

I track the size of my 2005 database (monthly) and store the size info in a database table.

I would like to be able to make a line graph to represent the growth trends.

Can this be done by an SSIS package? Does anyone know of a free tool that can create a chart or graph from a SQL Server table?

Thanks
John

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2009-10-28 : 10:37:29
How about Excel?

Or if you insist on Free, try the spreadsheet application in Open Office.

________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2009-10-29 : 13:21:50
Thanks blindman. I'm struggling with making a chart from Excel on my desktop, using an ODBC data source to retrieve the table rows. That is working, just trying to assign the correct field names to the axis, etc. I'm using the trial-and-error approach because I've never really worked with Excel's charting feature.

John
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2009-10-29 : 13:26:03
I would ask some questions on an Excel/Office forum somewhere, or refer to Excel's help files.

And, remember: experiment with small, simple sets of data, just typed in by hand, in Excel to learn about the graphs and charts. Then, once you get the basics and you are feeling good, consider trying things like working with larger sets of data.

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page
   

- Advertisement -