Excel 2 Y Achsen. When the values in a 2 d chart vary widely from data series to data series or when you have mixed types of data for example price and volume you can plot one or more data series on a secondary vertical value axis. It can be very helpful to put multiple data trends onto one graph in excel.
Jeweils zwei der drei zusammengehörenden säulen zeigen euro beträge zwischen 4 000. Right click a column in the chart and select format data series in the context menu. Ein excel diagramm mit 2 y achsen hat neben der horizontal verlaufenden x achse zwei unterschiedlich skalierte vertikale y achsen.
In the plot details dialog box click the link axes scales tab layer 2 and set x axis link to none and click ok.
But if your data has different units you may feel like you can t create the graph you need. But have no fear you can and it is actually pretty easy. In the graph window right click on the layer 2 icon and choose layer properties. Then in format data series dialog check.
