Changing the Type of an Existing Chart

Problem

You've created a chart but later decide a different chart type would be more effective. You'd like to change the chart type without having to re-create the chart from scratch.

Solution

Select your chart and right-click on it with the mouse. On the pop-up menu that appears, select Chart Type to open the Chart Type dialog box, which is the same as that used during step 1 of the Chart Wizard (see Figure 4-2). Select the new chart type and sub-type and press the OK button when you're done.

Discussion

As a simple example, reconsider the data used in the example for Recipe 4.1. The force data is a function of heading in degrees from 0 to 360. In the previous example, we used an XY chart type that showed the data series as a function of heading angles along the x-axis. A better way to view this data would be to plot the force data radially as a function of heading in a polar plot fashion. In Excel this type of chart is called a Radar chart.

Figure 4-18 shows what the data from Figure 4-1 looks like as a Radar chart.

I should mention that Radar charts require the x-axis data to be evenly spaced. The heading data for this example is the x-axis data, but for this Radar chart the heading data is merely used for labeling the chart; it does not govern the structure of the polar axis. The spacing of radial gridlines on Radar charts is always uniform. The number of radial gridlines will equal the number of data points in the series being plotted.

Figure 4-19 shows the Source Data dialog box for this example. To access this dialog box, select the chart and right-click to display a pop-up menu. Select Source Data from the pop-up menu.

The cell range in the Values field is the range of cells containing the y-data to be plotted, the force data in this example. The heading data happens to be uniform and ranges from 0 to 360 degrees. These facts make the chart appear as you would expect. To force the chart to display the heading angles on the radial axis, you have to supply the cell range containing the heading data in the "Category (X) axis labels" field. Since we converted this chart from an XY chart, Excel filled in the label field automatically.

Figure 4-18. Radar chart

You'll notice that this chart looks a little fancier than some of the other examples discussed earlier. All I did was format the chart a little differently by including a background image as the fill pattern for the chart itself, and by tweaking the title and grid line colors using their format options. See Recipe 4.3 for more information.

Figure 4-19. Source Data dialog box


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