Chart Wizard is a powerful tool for quickly building charts of any complexity from scratch, and customizing existing charts.
The Wizard is organized in two main areas: the toolbar on the left (which lists pages, that in turn, are organized in two groups: Construction and Presentation), and the main pages area, where all the options are represented by tabs, and where the real-time chart's preview is situated. And, the panel at the bottom provides quick navigation through the Wizard's pages.
The tutorials in this section describe how to add a chart to your query results and provide data for it. In this example, we'll use the Chart Wizard to create a simple chart.
- Click on New Query in the toolbar and select the Windows Event Log log input format(default)
- Write the following query
and run it to get results:
select EventTypeName, count(*) as [Number of events] from System group by EventTypeName
- Click on View->Display Chart on the toolbar to show the chart panel and click on Chart Wizard to open the Wizard. Then, proceed with the Wizard's steps, to construct the chart.
- On the first Chart Type page, choose the Bar chart type. The type specified at this step is not absolute, and you will have the option to change it in another Series page, because the chart type (the diagram type) is determined by the view type of the series it displays.
- Switch to the next Appearance page. Here, you can choose the look-and-feel for your chart by specifying its palette and choosing its specific style
- The next Series page is where you actually determine the type of your chart. By default there are two series. For this sample remove the Series 2 and set the name of Series 1 to “Event Type”. It depends on which view type has the first visible series in the chart's collection. And, in order to combine multiple series of different types within the same chart, their view types must be compatible (for instance, Pie Chart and Bar Chart are not compatible). On this page, after you have created a series of the required types, ensure that their value scale types are defined appropriately (in this case Numerical). Because declaring an accurate scale type series points' values is crucial for getting the correct output. The argument scale types are defined automatically, by default. By default there are two series
- The next Data page provides options for populating the series with points. This can be either done manually (by specifying arguments and their values for each point) or - in our case - automatically (by specifying the data bindings for your series).
- Now switch to the “Series Binding” tab on the right of the wizard’s window and make the following assignments for the Series 1 properties: set the Argument property to the “EventTypeName” data field and the value of the Value property to “Number of events”.
- At this step, the chart's construction is finished, so you can click Finish to see the result. The pages in the next Presentation group allow you to adjust the appearance of the chart and its elements.
- Now you can adjust the following options.
- Adjust the series-view-specific options. For the created series, it is possible to color each Bar individually. To achieve this, select the Series Views page and Appearance tab on the right. Among the set of the specific options, locate and enable the “Color Each point” property.
- Add a chart title. To create a title for your chart, select “Chart Title”. Then, on the right side click Add, and for the created title, set its Text and other options.
- Adjust the series point labels. To show the series labels select “Point Labels” page then enable the Visibility property. You can change label format in “Point options” tab.
- Hide legend in the Legend wizard page.
- Click on Finish and view the result.