Creating Data Access Pages with Charts using Office Web Components - Monthly temperature chart for Princeton continued
(Page 3 of 5 )
When you choose the table, the field list corresponding to that table is added to accompany the page as shown. You may also place a check mark against Plot detail records as shown.
Another change that occurs is that the OWC shows some drop-down areas for the various fields. These are place holders for data that you drag and drop onto them from the field list.
Click on the Month in the field list (if it is not visible just right click on the OWC and the list should pop up), then click on the Drop Categories Fields Here at the bottom of the OWC as shown. Also drag and drop the Temperature and RecHigh fields into the Drop Data Fields Here place holder location at the top.
This changes the chart as shown in the next picture. You may also drop these fields inside the data area where the chart appears. If you need to remove them you may highlight so that it sprouts handles and then use the cut submenu from the Edit menu item.
Now click on the OWC and from the drop-down menu click on the Commands and Options... menu item. This brings up the Commands and Options window as shown, with several tabs.
In the General tab you can add multiple charts, as well as legends and titles.
In the Borders/Fill tab you can make choices to make the chart very "jazzy" or make it look very conventional as shown. You can fill the chart with your choice of colors or choose a preset color scheme.
The next tab, Data Details, is the same we saw earlier, and the screen shot is skipped. The Type tab allows you to choose the type of graph or chart. The one chosen here is the column graph.
In the next tab, Series Groups, you group the series and also add the axes. For example, the scale of the temperature can be added to the graph. In this case, it was added to the left of the chart as shown.
The next tab, Show/Hide, shows the default options of whether a certain feature is showing or hidden.
Now you can view how the page looks by clicking on the View --> Page View from the main menu.
In this view if you click on the Month drop-down, you may deselect certain months if you want and the interactive chart would show views for only the active months as shown (February, November, and October are missing). This is certainly a nice feature when you want to selectively filter data.
You may now save this page from the file menu. This page in this tutorial was saved as Prctntemp.htm in the default directory C:Documents and Settingscomputer userMy Documents Before the page is saved it warns you about the datasource location information not being an UNC path.
After making a few more minor changes to the formatting the page appears as shown in the next picture when opened in IE 7.0.
Next: Creating an X-Y graph >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 4 
