In the range E9:E10, add Column sparklines using the data in range B9:D10. Ungroup the sparklines and then set the vertical axis maximum value to -15000 for cell E9 and to -60000

Question

Gudrun wants to compare future payments for three different scenarios for a park's bond offering. Switch to the Bond Offering worksheet. She has already entered formulas in the range B9:D10 to calculate the quarterly and annual payments for each option.
In the range E9:E10, add Column sparklines using the data in the range B9:D10. Ungroup the sparklines, and then set the vertical axis maximum value to -15000 for cell E9 and to -60000 for cell E10.
Gudrun wants a clustered column chart comparing the costs of the bond options.
a. Create a Clustered Column chart based on the values in the range A9:D10.
b. Resize and reposition the chart so that the upper-left corner is located within cell A11 and the lower-right corner is located within cell D28.
Customize the chart in the range A11:D28 as follows:
a. Enter Bond Offering Cost Comparison as the chart title.
b. Add Data Labels to the chart.

davidmacago · Answer

Click E9 and drag it to E10 (or click E9 hold shift and click E10). Go to insert tab click Column. Alternatively, you can search "Column Sparkline", which is at the middle of the topmost section, and find it. Enter B9:D10 for the data range. Go to Sparkline tab. Click Ungroup. Click on cell E9. After that on the same tab, Click Axis. Under Vertical Axis Maximum Value, click Custom Value and enter -15000. Click cell E10 and then repeat the same step but enter -60000
a) Select A9:D10, go to insert tab. Click recommended chart and select Clustured Column. Or, you can click on Bar Chart options from the icons next to the Recommended Chart icon.
b) Move the mouse to the corner and drag it and extend at A11:D28
a) Double click on the Chart Title and enter Bond Offering Cost Comparison.
b) Click on the + sign beside the chart and then check Data Labels option.

Video explanation:

Answers