Excel for Marketing Managers

Finding Maximum Area and Volume

Finding Max
Area and
volume

column Sub-type (default). (Push Press and Hold to View Sample to see

what your chart will look like.) Press Next.

c. Step 2 shows you the data range selected and the series. Press Next.

d. In Step 3, under Titles, type in a Chart title as follows: Farmer's Fence

Under Legend, click on the Placement radio button for Bottom.

Press Next.

e. In Step 4, select “As object in:” and press Finish. Excel places the fin-

ished chart on your worksheet.

f. Move and re-size the chart.

Click on Draw → Snap To Grid. Left-click to select the chart and drag it

so that the top is on row 29 under the barn. Use the right and left han-

dles to make the sides of the chart line up with the barn. (It should ex-

tend from column H to column M.) Use the bottom handle to drag the

bottom of the chart to row 53.

Figure 251

Inserting a line

chart