Data Analysis and Presentation Skills Part 5 potx

Diet B and Diet C as these are the labels on the worksheet. Sometimes we may

want to change these or correct mistakes. Enter edit mode by selecting the

graph and choose Source Data after clicking with the right mouse button.This

takes you back to the step where you selected rows instead of columns. Click on

the Series tab. From here you are able to select the data in each row and in the

name box rename each label in the legend, as shown in Figure 3.26.

A further option that we might want to include is to show a table containing

the data itself beneath the plot. Once the chart is complete you can edit the

graph (by clicking on it) and then select Chart Options from the menu. Click

on the Data Table tab and by selecting Show Data Table, as can be seen in

Figure 3.27, a data table is displayed beneath the plot.

Grouped 3-D bar charts

The information can be conveyed again slightly di¡erently by using a three￾dimensional bar chart. Here bars may be placed in front of or behind each

other and so give emphasis to components of the plot.

In Excel, re-plot the weight loss information; this time select the 3-D

Column option, placing the data back into columns instead of rows. On the

three-dimensional plot it would be more appropriate to have the label ‘weight

loss’at the top of the axis with the text written horizontally (remember we read

from left to right) rather than written vertically so that the reader needs to turn

through 908 to be able to read it. To adjust the position of the label, select the

64 3 PRESENTING SCIENTIFIC DATA

Figure 3.25 Stacked column chart