chartingwithexcel-exercises（7页）.docVIP

UCL Education information support division information systems Excel 2003 Charting with Excel Exercises Document No. IS-038 v2  Content Task 1 – Charting category data Task 2 – More category data Task 3 – Charting time series data Task 4 – Charting relationships between numerical data Task 5 – Dealing with problems Task 6 – Amending an Existing Chart Task 7 – Plotting non-adjacent cells Task 8 – Formatting Charts Task 9 – Error bars Task 10 – Printing Charts Task 11 – Using Trendlines Task 12 – Copying charts into Word These exercises accompany the Charting with Excel workbook produced by UCL Information Systems. You will need to download files to accompany the course from www.ucl.ac.uk/is/training/exercises.htm – click on the Excel link to download the files. Task 1 – Charting category data Open the file time-activities.xls and , using the Chart Wizard, create a column chart to show how much time is spent on each activity. Note that the series are in columns. Use ‘Time spent on each activity’ as the chart title, ‘hours’ as the y-axis title, and ‘activity’ as the category axis title. Don’t include a legend since there is only one series. Create a second chart for the same data - this time as a pie chart: Display the category name, and the data as percentages of total time available (Step 3). Task 2 – More category data The file evals.xls contains evaluation data from a set of training courses. Seven courses were run, and the evaluations were split into four categories. 1. Create a clustered column chart to show just the Presentation and Instruction scores for all of the courses: In Step 2 the data should be organised in columns Use ‘Course Scores’ as the chart title, enter ‘Course’ as the category axis label, and use ‘Score’ as the value axis label. Embed the chart as an object within the current Worksheet. Position the chart in a suitable place on the worksheet and enlarge it if necessary to disp