Excel Charts

Excel Charts

Errata

Ideally, I would like every book that I write to be completely accurate and error-free. The fast-paced nature of the computer book publishing industry makes this goal difficult to achieve. However, I assume complete responsibility for the content of my books.

Listed below are known errors in my Excel Charts book. If you discover additional errors, please let me know.

• Page 71:
  The fourth paragraph contains a reference to range A1:E1, which is plotted in Figure 3-11. The data actually resides in A1:E5
• Page 79:
  The "Naming Cells and Ranges" sidebar fails to mention a simple way to name a range: Select the range, type the name in the Name box, and press Enter.
• Page 100:
  In the chart in Figure 4-7, the second category axis label should be 5-14 (not 5-4).
•  Page 119:
  The word "transistor" is spelled incorrectly in three places in Figure 4-23: Cell C3, and in both of the chart titles.
• Page 124:
  In the first paragraph, references to "top" and "bottom" should be "left" and "right."
• Page 130:
  The first bullet point states that the Plot Area color was changed. In fact, the color of the walls was changed.
• Page 151:
  The equation for a logarithmic trendline should be:
  
    y = (c * LN(x)) + b
  
  This equation is also incorrect in Figure 5-11, on Page 152.
• Page 152:
  The data shown in Figure 5-11 is a bit misleading. The value in cell A2 is actually 0.95, but it's formatted to display as 1.0.
• Page 202:
  The "dollar bill" chart shown in Figure 6-24 is not in the example file on the CD-ROM. Click here to download a zip file that contains this example.
• Page 205:
  The range reference in the caption for Figure 6-27 should be A1:C8 (not A6:C8).
• Page 213:
  In steps 2 and 3, you need to precede the range references with an equal sign. It should read: =Sheet1!Sales and =Sheet1!Dates.
• Page 219:
  In point #6, the sentence should begin: Enter 1 in the... 
• Page 236:
  The second paragraph under "Creating a Very Interactive Chart" contains an extra word. It should read: The interactivity is provided by using Excel's built-in features...
•  Page 250:
  The formula at the bottom of the page should have a comma separating the two arguments (not a period).
•  Page 251:
  In the second to last paragraph, the cell reference should be A5 (not A6). The formula at the bottom of the page should be:
  
   =50%-A4
  
  It is correct in the workbook on the CD-ROM.
• Page 260:
  At the bottom of the page, the range reference in Step #1 should be A1:B13 (not A1:A13).
• Page 263:
  The formula at the bottom of the page is actually in cell D2 (not D3).
• Page 272:
  In Figure 8-34 both the X and Y error bars use the Custom negative option. The paragraph that precedes the figure should read as follows:
  
  In this example, X error bars are set to use the X data range (Custom negative option), and the Y error bars are set to use the Y data range (Custom negative option).
   
• Page 275:
  In the second to last paragraph, the range reference should be A2:A1001 (not A2:1001).
• Page 290:
  An incorrect image is shown for Figure 8-53. The correct image is:
  
  
• Page 291:
  The image shown for Figure 8-54 should be the image shown in Figure 8-53, on Page 290.
• Page 306:
  In the last bullet point on the page, the OpenedBy field actually displays all item (not New Accts).
• Page 317:
  The second bullet point refers to Product as the Page field button. Actually, it's Location.
•  Page 322:
  The first sentence in the Note at the bottom of the page should be: Keep in mind that the chart you create still depends on the data in the pivot table.
• Page 377:
  The Test procedure at the bottom of the page is a bit messed up. It should be:
  
  Sub Test()
      Sum = 1 + 1
      MsgBox "The answer is " & Sum
  End Sub
  
  Page 446:
  The last paragraph refers to declaring five variables. Actually, only four variables are declared.
  
   

### End of known errors ###