Search results
Results from the WOW.Com Content Network
Add or remove a secondary axis in a chart in Excel. When the numbers in a chart vary widely from data series to data series, or when you have mixed types of data (price and volume), plot one or more data series on a secondary vertical (value) axis.
Charts typically have two axes that are used to measure and categorize data: a vertical axis (also known as value axis or y axis), and a horizontal axis (also known as category axis or x axis). 3-D column, 3-D cone, or 3-D pyramid charts have a third axis, the depth axis (also known as series axis or z axis), so that data can be plotted along ...
By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs.
Change axis labels in a chart. 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 source data for these axis labels.
To create a chart, you need to select at least one cell in a range of data (a set of cells). Do one of the following: If your chart data is in a continuous range of cells, select any cell in that range. Your chart will include all the data in the range.
A scatter chart has two value axes: a horizontal (x) and a vertical (y) value axis. It combines x and y values into single data points and shows them in irregular intervals, or clusters. Scatter charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data.
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 volumes.
The horizontal (category) axis, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling options than are available for a vertical (value) axis, also known as the y axis, of the chart.
Reverse the plotting order of categories or values in a chart. On a chart, do one of the following: To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis.
Change the text and format of category axis labels and the number format of value axis labels in your chart (graph in Office 2016 for Windows. You can also set other options in the Format Axis task pane.