Excel for Marketing Managers

Finding Maximum Area and Volume

Finding Max

Area and

Volume

8. Create the chart.

a. Select C14-E63 (the entire calculations table including headings).

b. Click on the Chart Wizard icon in the Standard toolbar (shows a verti-

cal bar chart). Select the Line Chart type and the middle row, left-most

Figure 250

Setting the incrementation value,

building the calculation table, and

finding the maximum value