Microsoft Office Tutorials and References
In Depth Information
STEP 4: TEST AND REFINE
6. Enter a name and (optionally) a description for the custom chart type (see
Figure 2-31).
7. Click OK and you’ll see your new custom chart type listed in the Chart
type list box.
8. Click OK again to close the Chart Type dialog box.
STEP 4: TEST AND REFINE
The final step is to test your creation. You should test the custom chart type with a
different data series. For this example, you need to do a multiple selection.
1. Select the range A1:F1, press Ctrl, and then select A3:F3.
2. Click the Chart Wizard button.
3. Select the Custom Types tab in the Chart Wizard dialog box.
4. Choose the User-Defined option.
5. Select the Survey Results item in the Chart type list.
6. Click Finish.
Voilà! The data will be displayed in a highly customized chart that is perfect in
every way. Or at least it should be. If the chart doesn’t look right, you may need to
make some additional changes to it. After doing so, you will need to go through the
previous steps to add the chart to the custom gallery. If you use the same name,
Excel will ask whether you want to replace the existing user-defined format.
Answer in the affirmative.
Figure 2-31: The Add Custom Chart Type
dialog box
Search JabSto ::




Custom Search