tailieunhanh - Data Analysis and Presentation Skills Part 5

Tham khảo tài liệu 'data analysis and presentation skills part 5', kỹ thuật - công nghệ, cơ khí - chế tạo máy phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 64 3 PRESENTING SCIENTIFIC DATA Mean Weight Loss in Male and Female Subjects following Diets A B and c Figure Stacked column chart 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 . 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 a data table is displayed beneath the plot. Grouped 3-D bar charts The information can be conveyed again slightly differently by using a threedimensional 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 90 to be able to read it. To adjust the position of the label select the PRESENTING GRAPHS AND CHARTS 65 Figure Editing the legend Mean Weight Loss in Male and Female Subjects following Diets A B and c 100 90 80 70 60 50 40 30 20 10 0 Diet c Diet B Diet A Diet c Diet B o Diet A Figure Displaying data beneath a graph 66 3 PRESENTING SCIENTIFIC DATA label to enter edit mode and right click the mouse button. From the .