After creating an additional vertical axis, it can be positioned within clicks. This method actually takes the previous method a step forward. Add Second Vertical Axis on Same Side in Excel Scatter Plot Read More: How to add secondary axis in Excel (2 easy ways)Ģ.
As we can see, the variation of the Y variable is hard to spot. We have created a simple scatter plot using this dataset. Insert Scatter Plot with Two Vertical Axis on Opposite Sides in Excelįor this method, we have the following 3 variables data set. In this short tutorial, we are going to dive into those methods.ġ.
But for more complex datasets, we require some extra methods. For simple datasets, this default option may be enough for us. When we create a chart, by default Excel creates a primary horizontal axis and a primary vertical axis. 3 Suitable Ways to Add Second Vertical Axis in Excel Scatter Plot