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.

Otherwise, leave this at "one" and every tick mark displays on the axis, whether it has a label or not. Click "Close" to close the Format Axis window and apply the changes to your chart.

Excel offers a wide variety of charts and graphs, each designed to help you uniquely visualize data. But choosing the right chart isnt always straightforward.