Switch x and y axis in excel mac
Scatter plot in Excel
When I select the data and 'insert line graph' Excel automatically makes my measurements the Y axis so it displays the graph horizontally. Even if I change the way the measurements are recorded on the page i. Can I do this? I searched help but unless you know the exact phrase to ask, help is unhelpful.
It seems such a simple thing to want to do, swap x and y data but I just can't see how to do it?? A Scatter chart has XY data which can be exchanged, a Line chart has Y data and categories data which is shown on the X axis always. Did this solve your problem? Yes No.
Sorry this didn't help. Skip to main content. Site Feedback. Tell us about your experience with our site.
How to Change the X-Axis Range in Excel Charts
But it does not tell you this right away. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies.
- How to Format the X and Y Axis Values on Charts in Excel 2013!
- nokia 6120 pc suite mac;
- Switching X and Y axis;
- conectar teclado mac a iphone.
- Excel 2013 For Dummies;
- How to create a scatter plot in Excel.
Swap x and y axis without manually swapping values Ask Question. Stars Data The first column is the Absolute Magnitude M of the star - I want this on the X axis The rest of the columns are the different spectral classes that have values from another column only in a particular range. Currently the chart looks like this and all I want to do is swap the axes, but I cant seem to do it. Click somewhere on the chart to select it.
Formatting Chart Axes (Mac) | ERC
Click on the " Design " tab. Sifu Sifu 6 What do you do if you don't get a Design tab? This does not swap the X and Y axes, this switches column data for row data. I haven't found any easy way of switching both axis which is a real pain.
RELATED ARTICLES
Nov 14 '16 at 8: That's the easiest way I know. That is indeed a possibility I hadn't considered. Thank you! Nov 27 '16 at Microsoft Excel for Mac v Here is what worked for me: Jaffer Wilson 2, 3 25 Excel puts data according to the column position. To swap coordinates, one option is to copy the left column to the right. Solved for me too.