Google Forms - Copy Summary Graph/Diagram to Use Elsewhere

By -
Google Form Icon
If you are looking at the summary view of the results for some Form data you have collected, you can  copy a chart or diagram that you want to use elsewhere very easily and quickly.

Simply hover over the chart or diagram, and a copy icon will appear in the upper right corner of it.  Click on that -

Arrowing pointing to copy chart icon
You will get a message that it has been copied to to the clipboard in the lower left corner - 

You can then paste it into the location you want to use it.  Here's an example in a G Doc - 
chart pasted into a document

I also pasted it into: Slides, an email, a Sites webpage, in my Blogger.  A nice feature addition that saves time from taking screenshots!

Comments

  1. BotikaMay 18, 2019 at 6:06 PM

    Man! Thanks a lot! U amazing! :)

    ReplyDelete
  2. Samir ChaudharyMarch 6, 2020 at 11:06 AM

    It is not working. What could be the problem?

    ReplyDelete
    Replies
    1. Melinda WaffleMarch 9, 2020 at 11:01 AM

      As I'm not sure about the type of question/graph you are trying to copy and paste, I cannot be sure. Some of the bar graphs I have noticed do not copy well. Sometimes you can have a browser issue as well. I would suggest trying: a different browser; a different type of graph; pasting into a different location - all can help you narrow down the issue.

      Delete
  3. UnknownMarch 19, 2020 at 3:36 AM

    Hi! I tried pasting it on Word/Publisher/PPT but it won't appear. It only appears when I do it on my email.

    ReplyDelete
    Replies
    1. Melinda WaffleMarch 19, 2020 at 9:30 AM

      I'm going to honest - I have not used MS Office in several years at this point. Perhaps creating a screen shot of it will work better in this instance? (Command + Shift + 4 on a Mac, snipping tool on the PC, varies on the Chromebook, but most of the ones I work with use Control + Shift + I can't get the graphic here, but it is the button at the top that shows all your open windows.

      Delete
  4. DoraMay 5, 2020 at 5:55 PM

    Hi, This only lets me copy and paste a picture. I need the actual chart and information pasted. Is that possible? Main reason is the chart is cutting off the labels and I can't understand the data.

    ReplyDelete
  5. UnknownMay 16, 2020 at 12:14 AM

    I can't paste a copied chart :(

    ReplyDelete
  6. UnknownJune 25, 2020 at 11:50 AM

    it won't let me paste anything.

    ReplyDelete
  7. UnknownJuly 23, 2020 at 6:21 PM

    i think just screenshot your graph if the copy option is not functioning well

    ReplyDelete
  8. UnknownJuly 30, 2020 at 5:01 PM

    It only works with Google Docs. Not outside programs.

    ReplyDelete

Post a Comment

Popular posts from this blog

Google Script - Create a Drop-Down List from Spreadsheet Column

By -
Image
(Updated on 3/21/2017 - triggers have been moved!) ( I just created a new related post on how to create a multiple choice  question on the form that a bit simplified - takes the "other" answers in a multiple choice question on a form, and updates the multiple choice options with those as options.) I guess it was only a matter of time before I ended up dabbling with Google Scripts.  Today I was asked by a teacher how he could populate a drop-down list on his Google Form from data on a spreadsheet - and have it update as he changed the data.  Not finding an add-on for this (why recreate the wheel? :-)  I explored creating a script.  And...discovered that this task is not too hard! To do this yourself - 1. Create your form.   Really important step.  Make sure to create your drop-down item and give it a title, but you do not need to add any options to it (because later you will populate it from the spreadsheet). 2. Create the spreadsheet where your list will reside. Yo
Read more

Google Script - Create Calendar Events from Spreadsheet Data

By -
Image
Yesterday I shared how I added reminder dates to a spreadsheet for a person in my department who keeps track of software subscriptions.  Today I'm sharing how we take the entries on that spreadsheet and create calendar events, so the reminders are built into her calendar. Here are the steps to create calendar events from spreadsheet data: 1. Either open the spreadsheet with the data (or create a new spreadsheet & populate it with data). This is the spreadsheet where I first added the script to add a "remind date" (yesterday's post). 2.  Open the Script Editor Go to the Tools Menu and select Script editor 3. Replace the Code Replace the default code - with this - (all the text highlighted in gray -  including the final bracket) function createCalendarEvent() {   var sheet = SpreadsheetApp.getActiveSheet();   var calendar = CalendarApp.getCalendarById(' calendarID ');     var startRow = 2;  // First row of data to process - 2 exe
Read more

Google Sheets - Flipping Your Rows & Columns

By -
Image
Let's say you have put together a sheet with information you THINK is how you want it.  And after using it for awhile, you realize you REALLY want the columns and rows switched.  Can you easily remedy this without re-entering all the data?  The answer is yes!  Before walking through how to easily do this, let me introduce you to a Google Sheets formula you may not know - it's called TRANSPOSE and it's purpose is to transpose the rows and columns in an array or range.  So, here is some data I have in cells A1-E2:  If I want to flip the columns and rows, I add the formula: =TRANSPOSE(A1:E2) in the cell I want to start the transposed information into.  And...viola!  My data is flipped: It needs to be noted that you CANNOT change data in the transposed cells.  As soon as you try to change the data in the transposed area you will get a REF! error because you have data in a cell it need to do the transposing.  The data is dynamic - if you change your original dat
Read more

Google Forms - How to Add a Video to Your Form

By -
Image
Google Forms underwent some radical changes in the last major overhaul.  In addition to being able to add images (all over the form), you can now include videos within your form for those taking it to be able to watch.  If you are a teacher, this means you can embed some video content right there in the form to then follow up with some understanding/comprehension questions.  Wow! If you prefer, here is a short video tutorial on How to Add a Video to Your Form . Here is how to add a video - First click on the question you want the video to appear BELOW.  Then click on the play button icon in the Add content bar - The Select Video window, you have 2 options - 1. Video search and 2. URL For the video search, where you can type in key words and then search for the video (PLEASE - if you are a teacher, preview the entire video you select from your search before having students watch it...) - Your search results will pop up below the search bar in a list, including thumb
Read more