Create an MS Excel chart showing historical values

In this example, we extract some BCL values for the flow gauge, q1, and then show them in an Excel chart.

Open the BCL table.
Filter the table so that it only shows BCL values for q1.

$images\chiclet.gif$ How?

Select Tools ® Office Links ® Analyze It with MS Excel to bring the values into Excel.
In Excel, mark the relevant columns to show in the chart:

ENAME

DATE

VALUE (reduced value)

Click the Chart Wizard button $images\ico_chart.gif$ and go through the wizard.
Click Finish to show the chart.

You can also show the hourly, daily and monthly values saved by IGSS by opening the database, Genhdm.mdb, located in the report folder and then extracting the relevant information as described above.