<div>
Perfect!!<br />
Just what I was looking for.<br />

</div>


<div>
<div class="content wysiwyg-content">
I have a SQL database with monitoring data from approximately 300 wells from 70 sites. <br />
<br />
I want to be able to open a folder for each site and view a graph of the monitoring results from each well at that site.<br />
<br />
The graphs would need to be live so that as additional data is added it shows up on the chart. &nbsp; &nbsp;<br />
<br />
The graphs would chart concentration over date and water level over time.<br />
<br />
I have SQL Server 2005 and Excel 2003. &nbsp;<br />
<br />
Does anyone know of an easy way to link excel to SQL to accomplish this or is another charting program the way to go?<br />

</div>
</div>


I have a SQL database with monitoring data from approximately 300 wells from 70 sites. 

I want to be able to open a folder for each site and view a graph of the monitoring results from each well at that site.

The graphs would need to be live so that as additional data is added it shows up on the chart.    

The graphs would chart concentration over date and water level over time.

I have SQL Server 2005 and Excel 2003.  

Does anyone know of an easy way to link excel to SQL to accomplish this or is another charting program the way to go?


Graph SQL data in excel or other charting program

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.