- Click on an empty cell; select Menu | Insert | Scatter | Select first
- Right click on the chart area: click “Select Data” | Add legend entries (series) | Pick X and Y values | Pick a name for the series for example “Comparison of size and rental cost of apartments” or in general “Comparison of X and Y" | click OK
- From "Chart Tools | Design | Chart Layout" pick the first one (layout 1) which adds the axis labels
- Remove the label on the right which contains the name of the series. This is redundant as the title already states the same
- Click on each axis title labels to select it, then click again inside it to change it to the real name of Y and X
Wednesday, June 17, 2015
Scatter Diagrams from any two columns in Excel 2010
In Excel 2010 to plot a scatter diagram out of two columns that appear in any position and any order follow this steps:
Friday, June 05, 2015
Subscribe to:
Posts (Atom)