ChartWizard

ActiveChart.ChartWizard Source Range(Cells(2, 8), Cells(num2 + 1, 9)), Gallery =xlXYScatter ... 

As well as performing an action, methods create a return value. The return value can be either True or False. Even the ChartWizard method creates a return value True if the chart was created successfully, False if the method failed. Usually you aren t interested in these return values. 

The material concerning charts has been changed extensively to reflect the changes that were made to the ChartWizard. The chapters on programming with VBA have been revised, and the chapters on creating command macros and custom functions using VBA have been completely re-written. 

Go with the mouse pointer to the menu bar, click on Insert, and in the resulting drop-down submenu click on Chart. A second box will appear, which lets you select a graph either On the spreadsheet, or As a separate sheet. Select the former by clicking on it. You will now see a succession of ChartWizard boxes that let you specify how the graph should look. You can achieve the same result with the keystrokes Alt + i, Alt + h, Alt + o, Enter, with i for Insert, h for Chart, etc. Either method will produce a dialog box labeled ChartWizard. 

The first ChartWizard box, labeled Step 1 of 5, asks you what area of the spreadsheet you want to be graphed. Since you already selected that area, the window with the heading Range should show = A 3 B 11. If it does, move the pointer to the Next > button, and click. If it does not, first move the pointer to the Range window, click, if necessary replace its present contents by A3 B11 (use the Delete key located to the right of the enter key, type A3 B11, and click again to deposit this), then click on the Next > button and proceed to step 2. 

The second ChartWizard box lets you specify the type of graph you want. Click on the XY (Scatter) plot your choice will be highlighted. (Do not select the Line plot, because it will automatically assume that all X-values are equidistant. This is convenient when you want to plot, e.g., income or expense as a function of the month of the year, or the region of the country. In scientific applications, however, it makes no sense to treat the X-values merely as labels, and it can yield quite misleading graphs.) Click on Next > to move to the next ChartWizard. 

The fourth box shows you a sample chart. The top right-hand corner will let you specify whether you want to plot rows or columns we will usually plot columns, and that will most probably already have been selected. On to the Next > step of the ChartWizard. 

Click on Insert, Chart, On this sheet, place the new graph next (or below) the earlier one, and answer the ChartWizard you already preselected the Range in step 1 as A 1 A 83, C 1 C 83. (When you prefer to type in the range rather than to point to it, this shows you the format to use, except that you can leave out the dollar signs just type A1 A83,C1 C83.) Answer the other ChartWizard queries, look at the result, and if necessary reposition the graphs to resemble Fig. 1-5. 

Select Insert => Chart, and complete the ChartWizard. You should get a result looking somewhat like Fig. 2.1-1, although the specific details will look different because every data set is different. Note the discrete nature of the count, with frequencies of 0,1,2,3 etc. Not surprisingly, the agreement is quite poor a highly discrete distribution such as obtained here cannot be represented very well by a continuous expression such as (2.1-1). 

Select Insert => Chart, and use the ChartWizard to select anXY plot, showing individual data points without a connecting line. Complete the graph Figure 2.2-1 suggests what it might look like. 

Click on Inserts Chart, and answer the ChartWizard to make the graph showing the three-point averages. Plot it it might look somewhat like Fig. 2.2-2. 

On the sheet, plot y(data) and y(fit) versus t. Since exponential functions are involved, select the semi-logarithmic plot in the ChartWizard. 

---