Search results
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.
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 and show textual groupings (or categories) on the horizontal axis.
Most chart types have two axes: a horizontal axis (or x-axis) and a vertical axis (or y-axis). This example teaches you how to change the axis type, add axis titles and how to change the scale of the vertical axis.
14 cze 2024 · In this article, you will learn how to change the Excel axis scale of charts, set logarithmic scale. and change X and Y-axis values.
6 wrz 2023 · In this article, we'll guide you through the steps of adding a second vertical (y) or horizontal (x) axis to an Excel chart. In Excel graphs, you're used to having one horizontal and one vertical axis to display your information.
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.
21 mar 2023 · The tutorial shows how to create and customize graphs in Excel: add a chart title, change the way that axes are displayed, format the chart legend, add data labels, and more.
