Placing charts, spreadsheets, and other screen objects into your article

How do you do it?

Before I go into the long explanation of how a chart can be added to your hubpage, I wanted to show you (as I have down below) that it can definitely be done.

The bad news is that there are many steps ... the good news is none of them are difficult or very time consuming. If you can point, click, drag your mouse, and press a few keys on the keyboard, then you can perform this task with relative ease ... you just need to know how it's done.

So, now that I have proven it's possible, I will move onto more important things ... like researching how to select the perfect band for your next bar mitzvah ... Okay?

What's that? You want a more in-depth explanation? Well ... You seem like a nice enough person, so I suppose I could go into a whole production number on how this is done. However, as my video editor is broken, you'll need to suffer through my slideshow approach.

Still in? Good! Let's learn how to add charts, screenshots, and anything else we can display on our screen into our articles. Okay? Roll 'em!


My sample chart

What's possible - what's not?

First off, let's talk limitations. I want to say 'If you can display it on your screen, then you can place it into your hub.' Well ... that's not exactly true.

For instance, you can't use my system to incorporate videos, but there are already other tools to get that task done. My method revolves solely around taking snapshots of your screen and changing them into pictures, so they can be incorporated into your articles. Are you still with me?

*But ... but ... I don't have a camera Yoshi!*

*sigh* Then I suppose our lesson here is done ... or maybe ... just perhaps ... you don't need one!

Did I see your eyes light up on that one? They should have, as that statement is 100% accurate.

I will show you how to take any screen image, make a picture out of it, and then allow you to add it to your article. Sounds like sci-fi, eh? Well then, let's make it so! (It sounds so much better when Patrick Stewart says it)

This is our Excel spreadsheet and our chart

What we want to do in this exercise is cut out the chart and turn it into a picture, so we can add it to our article. Sounds like fun, eh? Good!

Step one: capture the screen

*um ... okay ... you can take your hands off the side of the monitor now.*

To capture the screen image, you will press Ctrl-PrtScn on your keyboard.

Did you do it? Pretty anti-climatic, eh? For you see, nothing happened as far as your eyes are concerned, but - as you will soon see - something magical happened in the background, and we are about to tap into that. For now, we can close Excel, as we are done with the program

Nobody loves Microsoft Paint

This program comes with every edition of Microsoft Windows, but for some reason it never gets much love. Though it's plain and nearly featureless, it does have some wonderful uses, and I'm about to share one of them with you.

Let's open Microsoft Paint. You can easily open it by clicking start, then run, then type pbrush and press the enter key.

Got it open? Good! Now click edit and then click paste.

When I did it, I wound up with this:

Yep! That's our screen from earlier. As you can see, we now have a screenshot in Paint, which we can edit and manipulate to our heart's content! Let's start with removing everything but the graph. 

Click the dotted star icon in the upper-left corner and then click the dotted rectangle to the right of it. Then, drag a box around what you want to keep (in this instance, the graph).

Next, click edit and then click cut. Your screen should now look like this:

My chart! It's gone!

Where did it go!

Now, now, relax a bit. We just sent it to our magic place so we can clear off the rest of the junk we don't want. It will be back ... I promise. 

Click File and then click new ...

As you can see, now everything is gone. Happy? 

I'd leave you at that for being such an impatient little critter, but I do realize patience comes with seeing results, so I will show you some.

Click edit and then paste

You should now see this:

Now THAT is a result, and a very positive one at that!

Gives you ideas ... doesn't it? After all, we're still inside a graphics editing program (a primitive one, at that). What else can we do?

I know, let's add some text!

Wallah! There ya have it!

Of course, we don't want it there ... we want it inside our article, right? We need to save this as something.

Click file then click 'save as'. Where you see the dropbox for 'Save as type' choose JPEG and then enter a filename for your file and place it somewhere you will remember it later (highly important!)

Once that's done you can close Paint, open your article, then insert your graph, spreadsheet, chart, whatever, as a picture! Wahoo!

You can rule the world!

Or maybe not ... but you did learn something really cool today!

So what will you do with this newly found power? That, I leave up to you. Just be certain to bookmark this page in-case you forget later how this was done (ah, forgetfulness, the punishment for having to remember so much).

And so, I hope you will benefit from what I have taught you. As for me ... I'm off to research that bar mitzvah article ... Take care!

Was this article helpful?

  • Yes
  • Some of it
  • No
See results without voting

More by this Author


Comments 13 comments

Koby profile image

Koby 7 years ago from Ohio

You are the best. Who knew that taking screenshots was as easy as pressing two buttons?!

Well, I'm exaggerating, you DO have to push the two buttons at the same time... Oh the aggravation of computers...


dawei888 profile image

dawei888 7 years ago

Hi There Yoshi! GREAT HUB! This is EXACTLY what I'm talking about in my hubs - all hubbers are experts somehow or another and can contribute back something through teaching. I did not know about MS Paint and you've taught me something new. Thanks and Mazel Tov on the Bar Mitzva! dawei888


yoshi97 profile image

yoshi97 7 years ago from a land called 'what if?' Author

Thanks Koby and Dawai!

It's always a joy giving back to the community here. Everyone was so helpful when I started out, so I promised myself I would do the same for others when I grew a bit more wisdom about me. :)


Steve Rensch profile image

Steve Rensch 7 years ago

Outstandning. Bookmark for sure.

Oh, by the way, regarding that Bar Mitzva band, my brother's mother-in-law's cousin's gay boyfriend in Scranton . . .


lyricsingray 7 years ago

Yoshi, Shalom, and please help me I am trapped in a mac and do not have those buttons? Is there a mac way. Even if there is no way and devestating as this would be I am grateful for you sending me this and I apologize for such a late reply but I am still learning and didn't even know you sent it. How rude of me, that, and with my new website I have been running around like a mashigiana (spelling yiddish never took with me - probably because I am an official conservative convert, and proud-now I am rambling) You seem very kind and maybe if I need confirmation on a yiddish spelling word here and there you could help me and we could kibbutz for a minute or two.

Thank Yu again

Kimberly (Shoshauna)

ps- my husbands cousin lives in Israel but still sings for Bar Mitzva's here - if your ever n need, just thought you could put that in a fie somewhere LOL :-)


yoshi97 profile image

yoshi97 7 years ago from a land called 'what if?' Author

I did a little research and came up with something that might help you (and other Mac users)

Command-Shift-3 does a capture of the screen and Command-shift-4 creates a crosshair that lets you choose what you want to capture (cool, eh?)

Both of these create a file on your desktop.

Better yet ... Ctrl-command-shift-3 captures to the clipboard (as does Ctrl-command-shift-4), allowing you to paste it into a program where you can save it as a Jpeg file and import it into the Hubpages video capsule.

I hope this helps! :)

As for me being Jewish ... um ... afraid I'm not, though me and my girlfriend have a joke that I am a closet jew. You see, the Mormons came knocking at my door one door and I didn't want to be bothered, so I pointed to the church across the street and told then that's where I attended church ... I never realized it was a synogogue. Doh!

One thing I will say about the Jewish faith. I worked for a Jewish family a few years back and they treated me really good. As such, I learned to respect them and their culture. :)


jill of alltrades profile image

jill of alltrades 7 years ago from Philippines

Cool! I forgot about this function. I used to do it when preparing some powerpoint presentation.

Thanks yoshi97!


Kya profile image

Kya 7 years ago

Cool. In my version of microsoft unfortunately I did no longer find the legendary Paint, but I found I could download such a program easily via google:

http://en.softonic.com/s/microsoft-paint for MICROSOFT

or http://en.softonic.com/s/microsoft-paint:mac for MAC

Thanks for the tips, I'll try this out.


Staci-Barbo7 profile image

Staci-Barbo7 7 years ago from North Carolina

Yoshi, thanks to you and Kya for providing the helpful information on Microsoft Paint. It's one of those tools that you should probably know you have, but I didn't.


fortunerep profile image

fortunerep 7 years ago from North Carolina

that was the greatest hub of info yet, will print it out for I will have to study it, lol

diru


yoshi97 profile image

yoshi97 7 years ago from a land called 'what if?' Author

Thank you Staci and Fortune ... and many thanks to Kya to pointing out there are also alternatives for those who don't have the Paint program. :)


Eileen Hughes profile image

Eileen Hughes 7 years ago from Northam Western Australia

yoshi thanks for sharing that, it is a very helpful and detailed hub


GeneriqueMedia profile image

GeneriqueMedia 6 years ago from Earth

Great tutorial. Can you make a video of this and put it on YouTube?

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working