A graph or chart makes the spreadsheet productive and attractively visualizes the data. It is straightforward to create and add a graph – whether you are using Microsoft Excel or Google Sheets.

Trends in Excel predict future values using the TREND function, revealing data insights. TREND function utilizes known data to create a trend line for predictions.

Excel measures the distance between data points in a chart as a percentage. For example, if the gap width is 50%, the space between each column is half the width of the columns themselves.