Complete a creating Charts in Excel very accurately by following the step below.
Select year and click the “-” to remove years as a data object for the chart.
Next select the horizontal axis or Labels button and highlight the years to be the labels for the x-axis.
Click ok and Graph should look like this Lets move the chart to its own page.
Right click on the chart white space chart area. (not on column data and click “Move Chart”.
Check the radio dial to move to a new sheet.
The chart now occupies is own worksheet. Any changes made to the data will still be reflected on the chart.
Lets make sure our chart displays all important information like: Key, and Title, if they are not already present.
You can edit basic chart style by selecting your chart and then in the chart design tab that appears click quick layout and choose a layout with a title and key.
Lastly, lets change the default color scheme by either choosing a pre-made style from the chart design tabs or custom editing it yourself in the chart formatting tab menu, how it looks is up to you.
0
200
400
600
800
1000
1200
1400
1600
1991 1992 1993 1994 1995 1996 1997 1998 1999 2000
No. of Cases
No. of Cases Finished product
1. Copy the chart, and paste it in a new spread sheet.
2. Select the chart and change it to a xy-scatter plot.
3. Move it to its own full page worksheet.
4. Right click on one of the data points and select add “Trendline.
Formate the Trendline as a linear fit, and also select show equation and r^2 value (scroll down in trendline options to find r^2 option)
y = 24.303x – 47139
R² = 0.89118
0
200
400
600
800
1000
1200
1400
1600
1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001
No. of Cases
No. of Cases
Linear (No. of Cases)Final Graph.
Upload excel workbook to moodle.
