Saving Custom Chart Types

Problem

You find yourself repeatedly creating the same type of chart, with the same custom formats, titles, colors, and so on, and you'd like to be able to save your customizations so you don't have to redo them each time you create a new chart.

Solution

Add your customized chart to the Custom Types list to make it available in the Custom Type dialog box and Chart Wizard. After creating your customized chart, right-click on it and select Chart Type from the pop-up menu. In the Chart Type dialog box, select the Custom Types tab. Select the "User-defined" radio button toward the bottom of the tab. Press the Add...button to bring up the Add Custom Chart Type dialog box. Type a unique name in the Name field and type a short description in the Description field. Press OK when you're done; you should then see your custom chart's name added to the Custom Types chart list. Now you can select this type when creating new charts, instead of having to recustomize one of Excel's built-in charts each time.

Using Excel

Getting Acquainted with Visual Basic for Applications

Collecting and Cleaning Up Data

Charting

Statistical Analysis

Time Series Analysis

Mathematical Functions

Curve Fitting and Regression

Solving Equations

Numerical Integration and Differentiation

Solving Ordinary Differential Equations

Solving Partial Differential Equations

Performing Optimization Analyses in Excel

Introduction to Financial Calculations

Index



Excel Scientific and Engineering Cookbook
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors: David M Bourg

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net