Search results
Results from the WOW.Com Content Network
Learn how to customize the minimum and maximum values, the tick marks, the display units, and the logarithmic scale of the vertical axis in Excel charts. Follow the steps to select the axis, format it, and apply the options in the Format Axis pane.
Learn how to switch rows and columns of data in a chart by using the Switch Row/Column option on the Design tab. This article also explains how Excel determines the axis for data series based on the number of rows and columns in the chart.
Learn how to adjust the interval, placement, order, and type of the horizontal (category) axis in a chart. Follow the steps to select the axis, format it, and change the axis options in Excel for Microsoft 365.
Learn how to display or hide, format, and customize axes in Excel charts. Find out how to adjust tick marks, labels, alignment, orientation, and text of horizontal, vertical, and depth axes.
Learn how to use a secondary axis in Excel to plot data series with different scales or types on the same chart. Follow the steps to add or remove a secondary axis, and see examples of combo charts and axis titles.
Learn how to create a chart and add a trendline in Excel using recommended charts, pre-built templates, or custom settings. Follow the steps to select data, insert chart, edit data, and customize chart elements.
Learn how to reverse the order of categories, values, or data series in a chart by using the Format Selection or Select Data options. This can help you improve the visibility and readability of your chart axes and data markers.
Learn how to select data for a chart in Excel by using a continuous range of cells or nonadjacent cells or ranges. Find out how to arrange data for different chart types, such as column, pie, doughnut, XY, or stock charts.
Learn how to update the data in an existing chart from its source. Edit a chart in Excel, create a chart from a table, and update a chart source.
Learn how to edit, format, and customize the text and numbers of the horizontal (X) and vertical (Y) axis labels in Excel charts. Follow the steps to change the source data, the label range, the font, the spacing, and the number format of the labels.
Learn how to format a trendline to a moving average line in Excel by selecting the Moving Average option in the Format Trendline pane. See the steps and examples for adding, formatting, and projecting a moving average line to a chart.