
Create a chart from start to finish - Microsoft Support
Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.
Add a trend or moving average line to a chart - Microsoft Support
Learn how to add a trendline in Excel, PowerPoint, and Outlook to display visual data trends. Format a trend or moving average line to a chart.
Display or change dates on a category axis - Microsoft Support
When you create a chart from worksheet data that uses dates, and the dates are plotted along the horizontal (category) axis in the chart, Excel automatically changes the category axis to a date …
Present your data in a scatter chart or a line chart
In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. As a general rule, use a line chart if your data has …
Add, change, or remove error bars in a chart - Microsoft Support
In Excel, Outlook, PowerPoint, or Word, for Windows and Mac, you can format (add, change or remove) error bars in a chart.
Add or remove a secondary axis in a chart in Excel
The scale of the secondary vertical axis shows the values for the associated data series. A secondary axis works well in a chart that shows a combination of column and line charts. You …
Use sparklines to show data trends - Microsoft Support
A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, …
Add a data series to your chart - Microsoft Support
Add a data series to a chart in Excel. Show a new data series in your chart (graph) by including the series and its name in the chart source data.
Display empty cells, null (#N/A) values, and hidden worksheet data …
Change the way that empty cells, null (#N/A) values, and hidden rows and columns are displayed in a chart Click the chart you want to change. Go to Chart Tools on the Ribbon, then on the …
Change the display of chart axes - Microsoft Support
Value axes provide a variety of options, such as setting the scale to logarithmic. Other chart types, such as column, line, and area charts, show numeric values on the vertical (value) axis only …