Where is the y axis on excel

This chart has the X-axis horizontal with values from the Sales column and Y-axis vertical with values from the Quantity column. When you create a chart in Excel, it automatically decides the range that needs to be shown in the axis.

Now, if you want to display Sales values on the Y-axis and Quantity values on X-axis, you need to switch the axis in the chart. Finally, your chart has a switched axis. How the heck do you do this? Improve this question. Add a comment. Active Oldest Votes. I don't understand quite. What kind of graph do you want? Improve this answer. Gaff Rook Rook That looks like an inverted hockey stick graph ; Hooray for the end of global warming! Actually, I was plotting some long term temperature data In Excel , a scatter plot also interprets the two columns as two data series : — O.

Hell, no! It's Microsoft! Toc Toc 1, 5 5 gold badges 20 20 silver badges 26 26 bronze badges. In legend entries column,click "year", then click "remove" In horizontal axis labels, click "edit".

Axis label range appears. Highlight the data cells of year excluding the cell of text "year" to avoid misunderstanding by Excel. Click "ok", than "ok" again. Go to chart tools, and click layout. Click axis. Click on tick marks, then click close. You've gotted it. A little preparation saves a lot of hassle. Jon Peltier Jon Peltier. Editing or changing any of the axes results in modifying how information is presented, what you can read from the chart, and where the emphasis lies.

With fewer marks and using bigger and smaller labels, your table will have a clearer structure, and your team will be able to use it without any issues. Additionally, you can also decide on the amount of space between the levels of labels.

Microsoft Excel allows you to format text and numbers in the category axis.