Đang chuẩn bị liên kết để tải về tài liệu:
Data Analysis and Presentation Skills Part 4

Tham khảo tài liệu 'data analysis and presentation skills part 4', 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ả | AN INTRODUCTION TO MICROSOFT EXCEL 45 Figure 3.7 First Step in Chart Wizard showing preview of plot Figure 3.8 Step 3 of Chart Wizard for inputting titles and labels In Step 2 of 4 you will now see the preview of the chart. N.B. by clicking on the Series tab you can edit the chart adding or removing data that you would like plotted. Click Next to continue. In Step 3 of 4 you may add titles and labels to your graph see Figure 3.8 . 46 3 PRESENTING SCIENTIFIC DATA Figure 3.9 Inserting the Chart Toolbar In the Chart title box type Species of butter ies at Paradise Common . In the Value Yaxis type number observed . Click on Next . In Step 4 of 4 you have the option of either placing the chart on a new sheet or embedding it on your present data sheet. Click on As object in and then click Finish. Your chart will now appear on your datasheet together with a toolbar from which you may edit the graph. If the toolbar does not automatically appear then it can be called up by clicking on View then Toolbars and selecting Chart from the list available see Figure 3.9 . You need to click on the graph to select it for the buttons on the toolbar to function. Try changing the graph from being plotted by column to by row by clicking on the appropriate button located towards the right of the toolbar see Figure 3.10 . Individual components of the chart can be edited using the selections from the menu on the left-hand side of the dialogue box. For instance the size of the chart can be adjusted by selecting Plot Area from the drop down menu on the left-hand side of the dialogue box. You can change the dimensions by clicking on one of the black handles that appear on the border and dragging the chart to the size that is required. AN INTRODUCTION TO MICROSOFT EXCEL 47 Figure 3.10 Editing the graph using the Chart Toolbar Changing colours and patterns in the chart Click on Series April from the drop down menu on the toolbar. You should see that all of the bars relating to April have been .