
Add or remove a secondary axis in a chart in Excel
In the chart, select the data series that you want to plot on a secondary axis, and then click Chart Design tab on the ribbon. For example, in a line chart, click one of the lines in the chart, and all the data …
Change the display of chart axes - Microsoft Support
Display or hide axes, or change other aspects of a chart axes in Excel, Word, Outlook, or PowerPoint.
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 (time …
Change axis labels in a chart - Microsoft Support
In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart). Your chart uses text from its …
Change axis labels in a chart in Office - Microsoft Support
Right-click the value axis labels you want to format, and then select Format Axis. Tip: If you don't see the Number section in the pane, make sure you've selected a value axis (it's usually the vertical axis on …
Create a combination chart - Microsoft Support
To emphasize different kinds of information in a chart, you can combine two or more charts. For example, you can combine a line chart that shows price data with a column chart that shows sales …
Present your data in a scatter chart or a line chart - Microsoft Support
To plot one of the data series along a secondary vertical axis, select the data series, or select it from a list of chart elements (on the Format tab, in the Current Selection group, select Chart Elements).
Present your data in a bubble chart - Microsoft Support
Scatter charts use sets of x values and y values, but bubble charts use sets of x values, y values, and z values. When you create a bubble chart, you can choose to display bubbles in 2-D format or with a 3 …
INTERCEPT function - Microsoft Support
Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y …
Add or remove titles in a chart - Microsoft Support
To make a chart easier to understand, you can add chart titles and axis titles, to any type of chart in Excel, Outlook, PowerPoint, or Word.