Change the Maximum value to $2,300,000 on the horizontal axis. Apply the Monochromatic Palette 4 color scheme to the chart. b. Add a secondary axis for the Total series.
Gudrun wants a stacked bar chart showing spending per park for each year.
a. Create a Stacked Bar chart based on the data in the range A4:E9.
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 F39.
Customize the chart in the range A11:F39 as follows:
a. Enter Spending per Park 2018-2021 as the chart title.
b. Change the Maximum value to $2,300,000 on the horizontal axis.
c. Apply a shape fill of White, Background 1, Darker 5% (1st column, 2nd row in the Theme Colors palette) to the chart area.
Update the Park Spending 2018-2021 combo chart in the range A40:G56 as follows:
a. Move the chart to the Projection worksheet.
b. Resize and reposition the chart so that the upper-left corner is located within cell A4 and the lower-right corner is located within cell K22.
For the Park Spending 2018-2021 combo chart, update the chart area as follows:
a. Apply the Monochromatic Palette 4 color scheme to the chart.
b. Add a secondary axis for the Total series. [Mac Hint: Select the Total series and use the format pane to add the axis.]
c. Add Axis Titles to the chart, and then enter Spending per park as the left vertical axis title, and then enter Total spending as the right vertical axis title. Finally, delete the horizontal axis title placeholder.
a) Select range A4:E9, got to insert tab. Select first icon (Insert Column or Bar chart) and then select stacked bar from 2-D bar. b) Move the mouse in the cornet of the chart and drag it to fit in the A11:F39
a) Double click on the chart title and enter Spending per Park 2018-2021 b) Double click on the chart. New section (Format Chart Area) will appear in right hand side. Click on Chart Options dropdown, select Horizontal (Value) Axis. Then, select Series Option (last icon). Click Axis Option. Enter 2,300,000 in maximum and it will automatically adjust. c) Click on the chart. Go to Format tab. Click Shape Fill and click White, Background 1, Darker 5% (1st column, 2nd row)
Right click on the chart , slect Move Chart. Select Projection option from the Object in. Drag it & move the mouse in the corner and then expand it to fit in the A4:K22.
a) Click on chart. Go to Chart Design tab and select color. Hover on the options to get its name.
b) Lil Tricky. Click on chart. Go to Chart Design tab. Select "Change Chart Type". On Choose the chart type.. section, scroll down and select Secondary Axis checkmark on Total. Then hit ok. Click on chart and select + icon. Click on the > of Axes and select Secondary Vertical. After that, click > of Axes Titles and check Secondary and Primary Vertical. Enter the given text on respective sides
b) Lil Tricky. Click on chart. Go to Chart Design tab. Select "Change Chart Type". On Choose the chart type.. section, scroll down and select Secondary Axis checkmark on Total. Then hit ok. Click on chart and select + icon. Click on the > of Axes and select Secondary Vertical. After that, click > of Axes Titles and check Secondary and Primary Vertical. Enter the given text on respective sides
Video Explanation: