Monday, March 18, 2013

Tutorial-Using Macros to Easily Graph WorldDataBank data in Google Spreadsheets

This is tutorial designed to easily help you create motion charts in Google Spreadsheets. I have linked to an Excel file from which you will be able to easily format the data as wanted. The advantage of using this method is that the data from WorldDataBank is not in the format needed to graph using Motion Charts. The macros contained in the Excel file will allow you to easily put the data in the correct format. Enjoy the video and happy Motion Graphing!

READ BELOW THIS IS IMPORTANT TO USING THIS TECHNIQUE!!!!!!


I was not able to directly upload the Excel file to Blogger because it is not allowed for security reasons. Because of this I have linked to a Dropbox folder containing the Excel file. In the video, the first step I give is to open the Excel file embedded on this Blogger post. Instead,

 CLICK ON THIS LINK TO GET THE EXCEL FILE NEEDED TO USE THIS TECHNIQUE, THEN FOLLOW THE STEPS AS SHOWN IN THE VIDEO

https://www.dropbox.com/sh/rh9sfu0ojt27313/6hnJ8y4aNE


No comments:

Post a Comment