How to Create a Scatter Plot With a Microsoft Word Spreadsheet

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Step 1: Insert a Chart

Image Credit: Image courtesy of Microsoft

Place the cursor at the spot you want your scatter plot to appear, open the Insert tab and click Chart in the Illustrations section.

Advertisement

Video of the Day

Step 2: Choose a Scatter Type

Image Credit: Image courtesy of Microsoft

Select X Y (Scatter) and pick one of the styles. Click OK to create a sample chart with a few points already entered.

Advertisement

Step 3: Replace the Sample Data

Image Credit: Image courtesy of Microsoft

Overwrite the sample data in the spreadsheet with your own data to start building your scatter plot.

Advertisement

Step 4: Add More Data

Image Credit: Image courtesy of Microsoft

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.

Advertisement

Advertisement

Step 5: Add Chart Elements

Image Credit: Image courtesy of Microsoft

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.

Advertisement

Advertisement

Video of the Day

references