Siegman
asked on
Graph SQL data in excel or other charting program
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just what I was looking for.