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.

Open Excel

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.

Views: 87

Comment by alsoknownas on June 30, 2016 at 8:41am

I just saved all my account statements in case I have trouble remembering The Great Recession.

Tried to make a graph of it but couldn't make the arrows show that far below the page.

Comment by JMac1949 Today on June 30, 2016 at 8:48am

I did thousands of graphs from Excel Speadsheets over my career.  Since I'm retired I don't think I've opened an Excel file more than a half dozen times.  R&L ;-)

Comment by koshersalaami on June 30, 2016 at 8:54am

Thanks. I'll know where to look if I ever want to make a graph and import it.

Comment by Rodney Roe on June 30, 2016 at 9:40am

AKA, I'm not at all accomplished in Excel, but I would guess you would need to make separate books.

JMac, someone else always had your job, so I did not become proficient at all.  The biggest thing that I've done with Excel since retirement is keep track of the daily rainfall at our house for a year with a running total.  I quit when my gauge froze and broke in January of 2010.  My next step would have been a weather station and I decided to let some other bored retiree do that.

kosh, part of the reason I posted this was so I would have a reference the next time I wanted to do it.

Comment by Arthur James on June 30, 2016 at 10:02am

`

AKA reminds me of

Clifford the Big Red

Dog? not Red Mule.

`

I get a Confound sense.

It sometimes a few days

of Ponderous Mood to

Begin To get Cognitive?

Simple Clarity... it okay

to send to? On Being?

Krist Tippet did a belief?

Brief Interview with ` Jon

Rabat Lodge. He no do any

kooky spews that do Confides?

no

Confuse and do

Befuddle Our?

Our Salon? huh?

`

goofy

EPOCH

Amen

`cc`

`

Comment by Arthur James on June 30, 2016 at 10:05am

`

oops...

not rabbi

Jonathan

Wolfman?

`

He no act as?

a Werewolf.

Jon Kabat 

Lodge is a

Science 

Meditator.

He Mediates

and Ministers

Some Combo?

no. Common

Sense that no

Bum Readers.`

`cc`

I try to type 

slow and seem

more articulant.

`cc`

`

Comment by Rodney Roe on June 30, 2016 at 10:55am

Art, articulate is good. I don't know jon rabbat lodge. However, that made me think of Henry Cabot Lodge who was a sort of an isolationist/American exceptionalism sort, but sometimes said smart stuff, like this;
"True Americanism is opposed utterly to any political divisions resting on race and religion."
That leaves out Donald Trump and most of the Tea Party.

Comment by Arthur James on June 30, 2016 at 12:00pm

`
GOOGLE?
`
KRISA
TIPETT?
`
ON BEING
`
I RAN ERRANDS.
LAWYERS STEAL
Ya'S 'BIC' ?
LIGHTER. HUH.
IF YA'S Pass ?
a 'BIC' LIGHTER
LAWYERS STEAL A
'BIC' PROPANE ?
LIGHTER - O RAN
OFF FROM OUR? I
THOUGHT BLOGGERS
WERE DIZZY? NAP ?
`
I WORRIED THE CHEM-
STRATE CLOUD FORMS
IN SKY CAUSED SOME
SLEEPYTIME SUMMERS
MOOD. MY NICE GUEST
THINK I OUGHT TO ?
SUPPY? no ` I 'ought
to supply ` TP-tissue.
`
I bought enough TP-rolls
to last my Lifetime . I
think W#e OUGHT to Be able
to buy just `1 ' TP- ROLL.
HOW MANY ` SQUARES DOES A
LAME FARMEr OR` LAWYER need?
`cc`
i JUST obliged.
i save 'CHARMNIN'
'TP SQUARES FOR
LAWYER etc;, Guest.
'`it' a GREAT TISSUE
INVESTMENT. I SHARE.
Tissue SQARES are ?
GREAT FOR BLOWING A
NOSE. No STUFF GOO ?
SNOT? IN YA'S POCKET.
no save nose snot goo.
Give away? on a raIN ?
DAY?
NO DO A
FARMER'S
ROCKET IN'
COURTHOUSE'
GROSS SAY ?
JUDGE ? GOO
IN THE COURT!
`CC`
`

Comment

You need to be a member of Our Salon to add comments!

Join Our Salon

NEW BLOG POSTS

1 Sentence GRIFTERS & MURDER

Posted by Jonathan Wolfman on October 19, 2018 at 1:39pm 5 Comments

Little Red Rooster

Posted by alsoknownas on October 19, 2018 at 9:04am 9 Comments

The Media and the Midterms

Posted by Ben Sen on October 18, 2018 at 9:30am 6 Comments

Not Since 1916...

Posted by Ron Powell on October 18, 2018 at 9:30am 8 Comments

A Feature, Not A Bug

Posted by Robert Young on October 18, 2018 at 8:51am 3 Comments

Hitman Jesus

Posted by Safe Bet's Amy on October 18, 2018 at 8:11am 0 Comments

© 2018   Created by lorianne.   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service