#Switch chart axis excel mac os how to#
#Switch chart axis excel mac os for mac#
#Switch chart axis excel mac os pro#

Not sure how I can incorporate just the 3 columns to actually put on the graph then get the numbers for the X-axis using that first column. I got the 3 lines I needed in my line graph, but then I had no X-axis again and the numbers I need for the X-axis are in my first column. I then tried just highlighting columns 2, 3, 4 and it worked great. In the Format Axis dialog, check Major unit ’s Fixed option, then in the text box, type a new unit you need. For a Scatter Plot, put your X and Y data in Header Columns (or Header Rows). Right click at the axis you want to change, select Format Axis from context menu. To get a Connection Line or a Trendline on the Scatter Plot, Format Panel > Series.

#Switch chart axis excel mac os how to#

Enough with the technicalities, lets move on to the reason why you came and learn how to change the color of a series in Excel.

#Switch chart axis excel mac os for mac#

This displays the Chart Tools, adding the Design, Layout, and Format tabs. I’ve tested this on Excel 2003, Excel 2007, Excel 2010, Excel for Mac 2011, Excel 2013 and the version included with Microsoft Office 365 (Including the online version). Select the text within the Axis Title box, then type an axis title. In a chart, click the value axis that you want to change, or do the following to select the axis from a list of chart elements: Click anywhere in the chart. Under Labels, click Axis Titles, point to the axis that you simply want to add titles to, then click the choice that you simply want. Click on the Chart (Graph) and Format Panel > Axis. Answer (1 of 6): Click the chart, then click the Chart Layout tab.

When I highlight all 4 columns and make a line graph it makes 4 lines (I only need 3) and the Y-axis is correct but there is no numbers for my X-axis. A Scatter Plot will allow you to change the Scale and Steps on the X axis. My first column needs to be my X-axis while columns 2, 3, 4 need to be the information that is on my chart (line chart) and the Y-axis. I have entered 4 columns of information in a spreadsheet with names above each column.

#Switch chart axis excel mac os pro#

I'm making a chart in numbers for a school project (used to use excel but with my recent purchase of my macbook pro I decided to lose Microsoft office and just use iWork 08.