Hi DeeCee,
To control the bar colors for a Pivot Chart, you can follow these steps:
- Click on the Pivot Chart to select it.
- Go to the "Design" tab in the Excel ribbon.
- Click on the "Change Colors" button in the "Chart Styles" group.
- Select the color scheme that you want to use for your chart. You can also click on "Customize Colors" to create your own color scheme.
- If you want to keep the same color for each bar regardless of the pivot, you can right-click on a bar and select "Format Data Series".
- In the "Format Data Series" pane, go to the "Fill & Line" tab.
- Under "Fill", select "Solid fill" and choose the color that you want to use for the bar.
- Click "Close" to apply the changes.
To remove the white background on the data points, you can follow these steps:
- Click on the Pivot Chart to select it.
- Go to the "Design" tab in the Excel ribbon.
- Click on the "Add Chart Element" button in the "Chart Layouts" group.
- Select "Data Labels" and choose the position where you want to display the labels.
- Right-click on one of the data labels and select "Format Data Labels".
- In the "Format Data Labels" pane, go to the "Label Options" tab.
- Under "Label Contains", uncheck "Value".
- Under "Label Position", select "Center".
- Under "Label Options", uncheck "Label fill" and "Label border".
- Click "Close" to apply the changes.