How to Create Free Printable Data Charts

by Emmanuelle Douglas

Sometimes a picture is worth a thousand words. This is definitely the truth when you need to illustrate financial data. Spreadsheets can be cumbersome when you are looking at values in a neatly placed grid. Include a data chart to illustrate the numerical data so users can see the variances and changes in the data. Free printable data charts are available as templates in your spreadsheet software or from free online resources.

Excel 2010

Open Excel 2010 and select the data that you want included in your data chart. Click the "Insert" tab and review the data charts that are available in the Charts group. Select a chart type and a chart from the drop-down list that appears.

Move the chart away from your data by right-clicking in the white space around the chart. Select "Move Chart" and "New Sheet." The chart is moved to a new worksheet.

Save the chart by clicking the "Save" icon the Quick Access Toolbar.

Google Documents

Open the Google Document template gallery. Type "Data Chart" in the search box. Review the templates that appear.

Click the "Use This Template" button to down the template.

Review the data on the first worksheet. Adjust the default values with your information for your data chart.

Review the revised chart on the second worksheet in the workbook.

OpenOffice

Open the OpenOffice template gallery. Type "Data Chart" in the search box. Review the templates that appear.

Click the "Use This" button to down the template.

Review the data in the worksheet. Adjust the default values with your information for your data chart.

Review the revised chart in the workbook.

About the Author

Emmanuelle Douglas has been an avid writer since 1990. Her first professional writing assignment was for "Oscar News," a local corporate Intranet website. She holds a Bachelor of Science in mathematical sciences from Clemson University.

Photo Credits

  • photo_camera graph bars image by Tomislav from Fotolia.com