How Do I Flip My Y Axis With The Categories In Excel For Mac 2017

This should not be very difficult, but I cannot figure out how to do it. I have a table similar to this%low%high 0 0 12 1 13 26. 19 90 94 20 95 100 When I graph it, excel defaults to having the first column on the x axis and plotting the second and third column as y values. I want the first column to be on the y axis instead. I assume there is an easy way to do this, but I cannot figure it out. Most of the things I have found from searching have suggested the 'Switch Row/Column' button, but that does something else.

Mozilla firefox app download. Thanks for the help. Here's a simple VBA routine that creates an XY Scatter chart from data that is arranged with Y in the first column and one or more sets of X in subsequent data. Select the range of data, or select a single cell within that range, and run the code. Sub ChartFromInput_YXX() ' assumes first column of input range has Y values ' assumes subsequent columns have X values ' assumes first row of input range has series Dim rngDataSource As Range Dim iDataRowsCt As Long Dim iDataColsCt As Integer Dim iSrsIx As Integer Dim chtChart As Chart Dim srsNew As Series If Not TypeName(Selection) = 'Range' Then ' Doesn't work if no range is selected MsgBox 'Please select a data range and try again.'

Formatting the Horizontal Axis Press Control on the keyboard while clicking on the horizontal axis, and select Format Axis from the dropdown menu. Because the axis is overlaid on the chart area, sometimes you will not get the correct dropdown menu (you will see the option to Format Chart Area instead). You can tell when the axis is selected because green dots will appear on the corners. Alternatively you can reach the Format Axis dialogue box by going to the Format tab under Charts toolbar and selecting Horizontal (Category) Axis from the dropdown menu found at the top of the Current Selection group (far left of the Ribbon). Then select Format Selection. Or, click on Horizonal Axis in the Axes group under the Chart Layout tab. Then select Axis Options. Other options under the Axes button in the Axes group include reversing the order of the labels (diplaying them left to right or right to left) and showing the axis without the labels or tick marks.

Double click on the horizontal labels of your chart. The 'Format axis' pane will appear at the right of your chart. - Tick the 'Values in reverse order' checkbox. You can do the same for categories: - Double click on the vertical labels of your chart and then tick the 'Categories in reverse order' checkbox in the 'Format axis' -> Axis options.

The quickest way to open the Format Axis dialogue box is to double click on the horizontal axis. In the Format Axis dialogue box there are many options for altering the axis, it's worth experimenting! For example, you can specify the number of categories between tick marks. From the Scale tab, under Interval Between Labels you can change the scale from 1 to 2 and every other label will be shown. Change it to 5 and only 2 of the labels will be shown (e.g. You can alter the appearance of tick types under the Ticks tab by choosing an option under Major tick mark type. Selecting Outside has them outside of the plot area and selecting None removes them, which is what we've chosen in the following example (notice the tick marks in the previous graphs?) It is also useful to know how to change the location of the axis labels.

You can do this by choosing an option under Axis Labels in the Ticks tab. High will move the axis labels above the plot area. If the axis is not at the bottom of the plot area (e.g. If there are negative numbers in the graph) you can select Low to move the axis labels to be below the plot area. In this example, because the axis is at the bottom of the plot area, Low and Next to Axis will be the same.

The Number section will allow you to format the numbers presented in the axis labels. Additionally, all kinds of visual changes can be made in Fill, Line Color, Line Style, Shadow, Glow and Soft Edges, and 3-D Format. Email not coming in outlook.

Use your own discretion when experimenting with these features. Alignment will change the alignment of the labels and will also allow you to change the text direction (horizontal, rotated, stacked). Formatting the Vertical Axis As with the horizontal axis there is a dialogue box for modifying the vertical axis. To get to it, double click on the vertical axis and the Format Axis dialogue box will appear.