Hide

Formatting Charts in Excel

You can download here the worksheet from this video to practice it by yourself!

Excel provides you with countless options to format your charts and tables.

You can increase the font size to focus attention to a title, or use a smaller font size to fit more information in a limited space.

Bolding, Italicizing or Underlining text will add that extra highlight to a key piece on the legend, an axis, or some data label.

Using different colors for various elements on your chart will make them easy to differentiate between, but keep try to keep it simple and professional. Use contrasting colors for adjacent elements such as neighboring bars or text on bars.

Take a look at the accompanying video for information on how to modify sizes and colors of shapes and text. You can change the background, title, axis and data labels, the legend and much more to create your own style and a unique feel to your chart.