# Digitize from Picture in a Chart

Document Sample

```					date       RATE, mm/d DAYS    Monthly Total        Annula Total= 58.19803 inches
1/1/1996         1.2     31          37.2
14                                    RATE, mm/d
2/1/1996        2.07     29        60.03
3/1/1996        1.35     31        41.85    12
4/1/1996        3.02     30          90.6
10
5/1/1996         3.6     31        111.6
6/1/1996       11.14     30        334.2    8
7/1/1996        8.27     31       256.37
6
8/1/1996        8.27     31       256.37
9/1/1996         3.9     30           117   4
10/1/1996         2.7     31          83.7
2
11/1/1996        1.83     30          54.9
12/1/1996        1.11     31        34.41    0
Jan-96 Feb-96 Mar-96 Apr-96 May-96 Jun-96   Jul-96 Aug-96
1/1/1997
RATE, mm/d

Aug-96 Sep-96 Oct-96 Nov-96 Dec-96
INSTRUCTIONS                         SCREEN CAPTURE

General problem: monthly ET rates
from a published paper look "odd" and
you want to check the annual ET in
units that are comprehensible to you.

Create a dummy table of dates and
rates in the units of the published
paper, mm/d.

Type 1/1/96 into cell A2 and 2/1/96 into
cell A3.

Highlight cells A2:A3. Grab lower, right
corner. Drag to fill through cell A14.

Type 1 into cell B2.

Calculate days/month in column C by
typing "=A3-A2" in cell C2.

Compute monthly total in column D by
typing "=B2*C2" in cell D2.

Highlight cells B2:D2. Double-click
lower, right corner.

Delete cells B14:c14.

Highlight cells A1:B13.

Create a column chart.
Find annual total in inches.

Type "=SUM(D2:D13)/25.4" in cell G1.

Import image of chart.

Select chart area. Right click to select
"Format Plot Area."

Select "Fill Effects…"

Select the "Picture" tab.

Press the "Select Picture.." button.

Find the directory where the
Chart.xls" resides.

Select the JPEG
"DigitizeThisPix_of_ScrewyET.jpg" as
the background image.

Select the Y-axis so the scale can be
forced to match the scale in the JPEG
which ranges from 0 to 14 mm/d.
Uncheck the auto scale of the Y-axis
and specify a minimum of 0 and a
maximum of 14.

For each month:

Grab end of column. Move up or down
to match black boxes of 1996 estimates.

Annual rate totals 58 inches.

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 4 posted: 8/7/2012 language: Unknown pages: 5
How are you planning on using Docstoc?