Format different colors in an Excel Chart (same-series data)

By default, within Excel, when you select a single-series chart, all data markers that represent the data points in that series are displayed in the same color. To use different color for each data marker, do the following:

1) Right-click on the data marker (i.e. the bar representing your data)
2) Select "Format Data Series..."

3) Select "Fill", then "Vary Color by Point" and close

The result is that each data marker have now their own color. Excel gives each marker a different color automatically.

4) If you don't like these colors and want to have another color for each specific marker, just do the following:

   a) Left-click on the data marker once --> All data marker will be selected.
   b) Left-click on one specific data marker --> Only this specific data marker will be selected
   c) Right-click on the marker and select "Format Data Point" --> "Fill" --> "Solid Fill" --> select your color