The Open Door Web Site
ALL ABOUT GRAPHS
Graph Drawing with MS Excel 2013
Graphical data can be effectively treated using Excel. Most students seem to know how to use it to draw bar charts but Excel can do a lot more.
Enter your data on a spread sheet. Important: Respect the convention for decimal points. It depends upon how your computer is configured, for commas or full stops.
To draw a curve of these data, highlight the data and open the graphing menu and select scattergram.
Note: A scattergram is best for the data we are using in this example since it is not at regular intervals (0, 0.1, 0.3, 0.5 etc.). When data is at regular intervals then a line graph is probably the best option.
There are plenty of scattergram options to choose from.
In this example we have chosen the scattergram with smooth lines and markers.
Now select the Chart Elements that will give you choices for the graph title, legend (key), gridlines and data labels.
In this example we have selected Axes, Axes Titles, Chart Title and Gridlines.
Give the graph its correct title. A pop-up menu will appear where you can choose the Text Options.
Now label your axes. Again, a pop-up menu will provide you with Title Options and Text Options.
Use Chart Elements, Axes and More Options to re-size your graph. In this case the vertical axis can be started at 30% Transmission.
Once the title and the axes labels are completed you can take a look at the style and colour options for your graph.
Finally, by right-clicking on the graph, you can choose to copy the chart so that it can be pasted into another document.
The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.
Donate to the Open Door Web Site using PayPal