Can you flip axis in excel

A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account. About Us Our team. How to switch between X and Y axis in scatter chart? Switch between X and Y axis in scatter chart Switch between X and Y axis in scatter chart To switch between the X and Y axis in a scatter chart in Excel, please do as follows: 1.

See screenshot: 2. See screenshot: 3. When you know how to reverse axes is essential, as it can help you be able to flip chart. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function.

If you want to save hours of research and frustration, try our live Excelchat service! We guarantee a connection within 30 seconds and a customized solution within 20 minutes. By continuing to use this website, you agree to their use. Connect anytime to free, instant, live Expert help by installing the Chrome extension Add Excelchat to Chrome.

Quick Excel Help. Get instant live expert help with Excel or Google Sheets. Post your problem and you'll get expert help in seconds Your message must be at least 40 characters. Our professional experts are available now. Your privacy is guaranteed. Now this tutorial will tell you how to reverse the axis order quickly in Excel. There is an option in Format Axis dialog for reversing the axis order. Right click the y axis you want to reverse, and select Format Axi s from the context menu.

See screenshot:. Tip: In bar chart, reserve the x axis with righting click the x axis and selecting the Format Axis from context menu, then checking the Values in reverse order in the Format Axis dialog box. Note: The other languages of the website are Google-translated. Back to English. Log in. Sometimes, when you create a chart in Excel, you may want to switch the axis in the chart i.

For creating a chart, I will be using the below data set, which contains products in column A, Sales value in column B, and Quantity value in column C. As a result, you get the scatter chart as shown below where I have highlighted the axis using the arrow.