How to Create a Scatter Plot With a Microsoft Word Spreadsheet
Learn how to create, edit and customize an XY scatter chart right inside Word -- no need to open Excel.
Things You'll Need
- Microsoft Office Word 2010
With Word 2013's ability to create a chart, you don't need to open Excel to build an XY scatter plot. Pick a chart style and enter values to plot the points on a graph. The only trick: You have to start by inserting a chart; entering your values into a table won't do the job.
Place the cursor at the spot you want your scatter plot to appear, open the Insert tab and click Chart in the Illustrations section.
Select X Y (Scatter) and pick one of the styles. Click OK to create a sample chart with a few points already entered.
Office 2013 introduced the Bubble and 3-D Bubble styles of scatter chart. These styles offer a z-axis by sizing the bubbles based on values in a third column of data. All other styles use only two data columns.
Overwrite the sample data in the spreadsheet with your own data to start building your scatter plot.
Edit the "Y-Values" cell to change the title on the chart.
Add as many values as you need in the two (or three) columns. As you add more data sets, Word automatically includes them in the scatter plot. Word also automatically adjusts the scope of the chart to fit all of the data. After entering all of the data, close the spreadsheet window.
Right-click the chart and choose Edit Data to reopen the spreadsheet.
Click Add Chart Element on the Design tab (or click the + icon next to the chart) to add, move or remove chart elements such as the title, legend and axis labels.
The rest of the Design tab offers other style options, including color schemes, styles and ready-made layouts in the Quick Layout menu.