How to display charts and graphs on your presentation

  • 2
  • Article
  • Updated 3 years ago
  • (Edited)
If you are looking for a way to display your spreadsheet data in form of a graph or chart, this article will show you how.

First, open up a spreadsheet and insert the data you would like to convert into a chart. If you have an existing spreadsheet, great!

After you’re done filling up your table, select all the cells you’d like to display. Go to Insert -> Chart.



In the Chart Editor, you will be given several options to choose from. You can display pie charts, line charts, bar graphs, comparison metrics, etc.



Under the ‘Chart types’ tab, you are given more customization options. Play around with it and select what applies. You can also manipulate the range: see A1:B10.



In the ‘Customization’ tab, you can edit the fonts and colors of the graph as well as other more intricate details.



After you’ve gotten your metrics looking just right, let’s add it to our presentation! We will need to publish our spreadsheet and grab the embedded code.

To do this, go to File -> Publish to the web. Select the ‘Embed’ tab.

You will be presented with a dropdown that allows you to select which elements of the spreadsheet you’d like to publish. You can opt for displaying both your data table and chart, or you can just select your chart alone.

You will then see an embed code. Select all and copy it.





Now, let’s head on over to our HTML editor and paste the code you copied in between the tags inside the configuration:



That’s it! You have now successfully added your data in chart form in your presentation.

If you can work your way through code, you may have fun looking at Google Charts which allows a lot more flexibility and options. The same procedure applies, just paste the code into the HTML widget between the tags.




If you have any comments, questions or concerns please reply below where we will be happy to assist.
Photo of Ashleigh

Ashleigh

  • 3,740 Points 3k badge 2x thumb

Posted 3 years ago

  • 2
Photo of Steve Thompson

Steve Thompson

  • 80 Points 75 badge 2x thumb
While this is great, it is less than ideal for those of us who do not wish to share corporate graphs publicly.  However, if Rise Vision would allow for a google account to be configured, then we would not need to share with the rest of the world, just the Rise Vision Google account.

Love to see this added to the product road map.  This currently holds us back from utilizing the product.

Steve
Photo of Gartree High

Gartree High

  • 806 Points 500 badge 2x thumb
Yes a private graph would be much better but thanks for the guide.
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Thanks for the feedback!