Charts and Tables

Three tabs at the top of the Results View let you switch among Chart, Table and Map. Charts and tables contain the same basic information, while maps contain a subset. (Maps are discussed in more details below.) You can change any of the selection boxes at any time, but typically you will follow these steps to create a new report.

  1. First, use the selection box at the top of the screen (the chart of table title) to choose a particular report, such as Monthly Supply Requirement, Groundwater Storage or Streamflow.

  2. Next, use the selection boxes attached to the chart's X axis (or at the bottom of the table) and the chart or table legend to pick the data dimensions you want to see on each axis of the chart or in the columns of the table. Different categories of results will have different data dimensions. For example, the Supply Delivered report has the following dimensions: years, demand sites, sources and scenarios, so you can therefore create a chart (or table) that has any two of these dimensions on the X axis (or in the table columns) and legend of the chart (or table). Examples of charts and tables you can create include: demand site by year (for one or more sources and a given scenario), source by year (for one or more demand sites and a given scenario), demand site by source (for a given year and scenario), demand site by scenario (for one or more sources and a given year). Some restrictions do apply. When picking a dimension for the chart's X axis or legend or the table's columns, you will also be able to specify whether you want to show all items in the dimension or only selected items. If you choose "selected" you will be shown a dialog box in which you can check off the items to be displayed. Also, you can select the level of aggregation or disaggregation of demands for the Water Demand and Supply Requirement reports by using the "Levels" button (located underneath the report title). For example, on Weaping River Basin results, choose "All Branches" for the legend. Level 1 shows demand for each demand site; Level 2 disaggregates demand by agricultural county and crop type (Agriculture West), industrial water use (Industry East), irrigation technology (Agriculture North), and single and multifamily (South City). When Levels is greater than 1, a "Match Names" checkbox appears; selecting this checkbox will group together branches with the same name. Set Levels = 3 and check "Match Names" to see that Flood Irrigation consumes nearly a third of the total Weaping River Basin demand in the Current Accounts.

  3. Next, you can use the various additional on-screen controls to further customize your chart or table.

  4. Finally, you can use the Toolbar on the right of the screen (or right-click on a chart) to customize the appearance of the chart or the table, to copy results to the Windows clipboard, and to print or export results to Microsoft Excel. Options on the toolbar let you select the type of chart, type of stacking, and formatting options such as 3D effects, log scales, grid lines, and the number of decimal places reported in numeric values. For charts that show results for just one year (i.e., the X axis dimension is not time), the animate button will play a movie showing the results for each year. Note that when more than twenty items appear on a chart, the legend uses patterns to differentiate the items. Lastly, click on the Stats button on the Toolbar to see the minimum, maximum, average, standard deviation, and root mean square for tabulated data.

Saving Favorite Charts

If you want to save a particular chart with all your formatting choices for later retrieval, you can save it as a "favorite." See Favorites for details. Combining favorites to form "overviews" in the Scenario Explorer View are a powerful way to get an overall perspective of your system. See Scenario Explorer for details.