EXCEL TECHNIQUES

DIGITIZING DATA using CHARTS and SCREENSHOTS – Step 5

5. Adjust plot scales to match original data scales as follows:

Procedure Steps:

5.1 Select the y-axis and format the scale using the previously noted values

 

 

Procedure Steps:

5.2 Then use number format on the date values to determine the minimum and

maximum date values...

 

Procedure Steps:

5.3 and modify the x-axis scale format to match the previously recorded values.

5.4 The chart datapoints will now overlay the plat image properly for final adjustment.

 

Reference Microsoft Excel Help for detailed instructions for each step.