So here we’re going to walk you through the main chart options you need to customise, depending on your chart type and the data you’re representing, the legend, and your chart and axes labels.
1 Enable legend
Select data in a table, click the Chart button up top and choose a type, and chances are you’ll see something like this. Ensure Legend is ticked in the chart’s Format options.
2 Style legend
Click to select the box containing the legend and you can customise almost everything, from the font options through to a gradient fill, stroke outline, shadow and more.
3 Place legend
Now click the Arrange tab in the Format panel. Instead of manually dragging the legend to resize or reposition it, you can fine-tune the values beside Size and Position.
4 Customise title
Add a chart title by ticking the box above Legend in the chart’s Format options, then double-click the text box that appears to change the title and customise the font.
5 Name axes
Now hit the Axis tab and tick on Axis Name. Again, double-click to type axes names and customise the font. Do this on both the Value (Y) and Category (X) sub-tabs (up top).
6 Sort X
In your Category (X) options, also change the Label Angle to make the bottom axis more readable – Right Diagonal works well. Add Tick Marks and Gridlines to taste.
7 Sort Y
Under Value (Y), increase the Major value under Steps to break up your axis and make it easier to navigate horizontally. Tick Axis Line if you added X axis Tick Marks.
8 Add labels
Finally, to label individual values, click one of the lines, bars, curves etc in your chart to open the Series options, then apply a relevant Value Label from the drop-down.
9 Name labels
Your labels will likely be all but unreadable once you first apply them. To get around this, click the annotated image below to see how you can clean them all up for better legibility.
Click Image to Enlarge: