Have you ever wanted to create a graph and insert it into a blog you are posting? Maybe not, but if you have I have worked out a way to do it.
I used Excel to create the graph. I chose something that I knew so that I would know whether the visual fit the data I entered. If you have Excel here is what I did.
In the first column type what will be on the ‘x’ axis. In the second column type what will be in the ‘y’ axis. I used integers in ‘x’ and their squares in ‘y’.
Next enter your data. I didn’t want to fool with making a formula to calculate ‘y’, but you can do that.
You should now have two columns of numbers under the appropriate headings.
Now it gets squirrely. Select “insert” Select “charts”. Select “scatter” Select the a scatter gram based on the type of data you have. For this I selected one that had few “x” axis entries. You can then keep lines, get rid of lines and change the name of the graph at the top.
All of that is relatively easy.
Entering the graph into a blog page requires conversion to some sort of image.
Click on the edge of your graph – not the middle because you may only copy a bit of data – and copy. Next open Paint. If you have Windows 10 Paint isn’t even listed. You have to type it into the search bar and then select the program.
Click on the box and select paste. You can then choose the format you want such as jpeg, BMP, etc. Save.
Here is my example. Fingers crossed.
Experiment #1 constructing a graph with a well defined curve
Experiment #2 A real scatter gram showing 4th Quarter earnings for some imaginary company over a 10 year period. (Including the great recession.)
NB. depending on the version of Excel that you have the navigation and prompts may vary.
Also, you can overlay graphs, add color, and have fun with the process.