Create and format a combination chart. Use the Info pane. Eyeglass lens cleaning kits are sold by each office. These kits are purchased from the supplier in various carton sizes. In a worksheet, you can calculate the cost per kit which depends on the carton size. Then you will calculate a selling price using the current markup percentage. The data are then to be plotted in a combination column-line chart.
3. In cell E5, key a formula to multiply the per-kit cost by 1 plus the markup percentage for the half-year in cell C12. Use absolute reference to cell C12 in the formula.
4. Copy the formula to E8. Use the Currency format from the drop-down menu in the Number group, for cells D5:E8.
5. Use the data in columns A, B, D, and E to create a Clustered Column chart. Move the chart to a new sheet using the Move Chart command. As the Above chart title, key Cost and Selling Price Comparison. Choose a Chart Style 26.