1 If you want to base the style of your custom chart type on a chart available in UNICOM Intelligence Professional, export a sample table from UNICOM 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 might prefer to begin by creating a new chart in Microsoft Excel. 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 for that area, and adjust the settings to your requirements. For example, if you double-click a chart legend, the Format Legend dialog 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, select the Custom Types tab.

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

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