Graphs are used to display trends over a long period of time. Use a line chart if you have text labels, dates, or multiple numeric labels on the horizontal axis. Use a scatter plot (XY plot) to show scientific data on a coordinate plane.
To create a graph, follow these steps:
- Highlight a range A1:D7.
- On the Advanced tab Insert (Insert) in section Diagrams (Charts) click Insert Graph > Graph with markers (Line > Line with Markers).
Result:
Note: If you are using number captions, clear the cell A1 before creating a chart. In this case, Excel will not accept the column A as a data series and will automatically place the number labels along the horizontal axis. If necessary, after creating the chart, you can enter a title in the cell A1.