How to Plot Two Things on the Same Y Axis in Excel. Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet.

Adding a Second Y-Axis Your new series may not be measured with the same range of numbers as the old one. To make the chart look better, you can plot the new series on a differently scaled y-axis.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

How to overlap two series in Excel Overlapping the two series is one way to clear things up a bit. In other words, let’s move the target series so that it’s on top of the actual value series.

Learn how to ignore zero values in Excel charts with step-by-step tips to create clean, accurate, and professional visuals.