Your first chart will always have Excel’s default colors and designs.
Fortunately, it’s easy to customize and edit your chart to your own liking.
If you want to edit your chart’s looks, click ‘Chart Design’ on the tab list.
(If you can’t see the ‘Chart Design’ tab, click your chart first and you’ll see the tab.)
To see how the style looks on your chart, just hover your mouse over the styles.
In addition, you can also add or remove chart elements:
- Axis Titles
- Chart Title
- Data Labels
Just click your chart and then click the plus symbol (+) at the upper right side.
To view how each element affects the chart, just hover your mouse over the elements and you’ll see a preview.
(Furthermore, click the right-pointing pointer “►” to view additional options.)
To do so, right-click on any part of the vertical axis and select ‘Format Axis’. A window will then open on the right-hand side.
Here, you’ll see different options to format the axis.
To center the boxes, change the ‘Bounds’ of the variable.
Let’s change the minimum bound to 70 and the maximum to 95.
(If you like to revert the bounds, just click the ‘Reset’ button.)