1 If you want to base the style of your custom chart type on a chart available in UNICOM Intelligence Reporter - Survey TabulationUNICOM Intelligence ReporterUNICOM Intelligence Professional, export a sample table from UNICOM Intelligence Reporter - Survey TabulationUNICOM Intelligence ReporterUNICOM Intelligence Professional to Excel, checking the Display charts check box and selecting the appropriate chart type setting the DisplayCharts property to true and the ChartType property to the appropriate chart type. Alternatively, you may prefer to begin by creating a new chart in Microsoft Excel. Note that some chart types require the data to be organized in a particular format. For details about creating charts in Excel and the ways in which different chart types display data, see your Microsoft Excel user documentation.

2 In Excel, double-click an area of the chart to display the formatting dialog box for that area, and adjust the settings to your requirements. For example, if you double-click a chart legend, the Format Legend dialog box appears and enables you to change the patterns, font, and placement of the legend.

3 When you finish formatting the chart, select the whole chart area (selection handles appear around the edges of the area) and choose Chart > Chart Type from the Excel menu.

4 In the Chart Type dialog box, select the Custom Types tab.

5 Click the User-defined option button, then click Add to display the Add Custom Chart Type dialog box.

6 Enter a name and description for the chart type and click OK.