Add Second Y Axis 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 can quickly show a chart like this by changing your chart to a combo chart.

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. Learn more about axes 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 the depth of a chart. Radar ... 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. 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. On the Chart Design tab, in the Chart Layouts group, select Add Chart Element, and then do the following: To add a primary vertical axis title, select Axis Title > Primary Vertical.

and then on the Format Axis Title pane, select Size & Properties to configure the type of vertical axis title that you want. 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.

The techniques shown here are performed in Excel. After creating a chart, you might need to add an additional data series to the chart. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits.

Charts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word. If your chart is on the ... When you create a chart, Microsoft Office Excel determines the axis on which the data series are plotted, based on the number of worksheet rows and columns that are included in the chart, placing the larger number on the horizontal axis.

If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.