Excel automatically inserts the graph, but it has no labels. Review the new green "Chart Tools" tab and ribbon at the top of the screen. If you don't see them, click the chart to enable them.

We now show a bar graph plotted with the data from the labels of Figure 3. Notice that the sales growth now appears to be fairly linear, while Figure 3 suggests rapid growth in recent years.

I created a pie chart of the data myself to determine if the figure was not drawn to scale. My figure appeared the same as this one but with the 15% and 22% labels interchanged.

Create graph paper in minutes. Make address labels. This one is a cinch for Excel and you can add lots of mini pictures to the labels to jazz up the aesthetics or use your company logo.

Learn more about scatter diagrams with this BBC Bitesize Maths article. For students between the ages of 11 and 14.