Microsoft Office Tutorials and References
In Depth Information
After changing the City filter and displaying the legend
value axis labels
labels for the four
Sarah wants to change the PivotChart from a column chart to a bar chart to take
advantage of the screen width, and she wants to change the colors of the data
4. Click in the white portion of the chart (if necessary) to deselect any chart control, and
then in the Type group on the Design tab, click the Change Chart Type button, click
Bar in the left list, and then click the Clustered Bar chart (row 1, column 1) in the right
list. The chart changes from a clustered column chart to a clustered bar chart.
5. In the chart, click the red data marker for Lansing, hold down the Shift key, click
the red data marker for Lansing a second time, and then release the Shift key. All
red data markers are now selected, and any property change you make in the
Properties dialog box will apply to all four red data markers.
6. Click the Border/Fill tab in the Properties dialog box, click the Fill Color arrow, and
then click the DodgerBlue color (row 3, column 4) in the color palette. The four
selected data markers change to the selected DodgerBlue color. See Figure 8-35.
7. Repeat Steps 5-6, selecting the other four data markers (the lower data marker in
each set), and clicking the Tomato color (row 8, column 13), and then click the Fill
Color arrow to display the color palette. The four selected data markers change to
the Tomato color. See Figure 8-35.