Label x and y axis in excel 2008 mac




Some videos you may like

The horizontal line is called the x-axis; the vertical line is called the y-axis.


  1. how to remove mac account password.
  2. hide icons on desktop mac lion.
  3. usb image writer for mac.
  4. Formatting Chart Axes (Mac).
  5. Related articles....
  6. format ipod nano for mac?

One of them will be a Value axis, which displays numerical values that measure charted categories, and the other will be a Category axis, which displays one or more data series that are measured against each other by numerical values. The field created by these intersecting axes contain visual indicators e. Axis labels automatically assigned by Excel when you create your chart connect this visual information with specific data categories, providing the context readers need to make sense of your chart.

Since axes and axis labels are such important parts of an effective chart, Excel provides extensive formatting options. Pie charts do not have axes. When setting up your chart, it is important to understand how Excel will display your worksheet data e. For basic information on how Excel converts worksheet data into charts, refer to About Charting and Creating a Basic Chart.

Both horizontal and vertical axes can be the Category axis. With the Category axis, you can change the interval of units between the tick marks. If your category axis is denoted by words or phrases, the Automatic option will suffice in most cases. Double click the Category axis The Format Axis dialog box appears.

In the Interval between tick marks text box, type the number of units you want between the tick marks of your chart's x-axis. Both horizontal and vertical axes can be the Value axis. With the Value axis, you can change the interval of units between the tick marks as well as set a maximum and minimum value for the axis. If your desired axis is the Category axis, refer to Changing the Interval of the Category Axis above. From the Categories list, select Scale.

The Format Axis dialog box refreshes to display the Scale options. To change the minimum value of the y-axis, in the Minimum text box, type the minimum value you want the y-axis to display. To change the maximum value of the y-axis, in the Maximum text box, type the maximum value you want the y-axis to display. To change the number of units between the y-axis tick marks, in the Major unit text box, type the number of units you want between the y-axis tick marks. To change the number of units between the Major units , in the Minor unit text box, type the number of units you want between the Major units.

From the Titles pull-down menu, select the desired axis. Horizontal Category Axis. From the Click here to add title text box, type the desired axis title. You can alter chart axes in certain ways through the Layout command tab. Depending what chart you are using, the Value and Category axes will be on either the x- or y-axes e.

You can change the order of categories, add or remove axis labels and tick marks, or change the scaling of the Value axis. When changing the scaling of the Value axis through the Layout command tab, you may only do so exponentially.

Making a graph in Excel 2008

From the Categories list, select the desired option. A legend will help readers understand the graphical components of your chart. For example, in a bar chart, the legend tells your readers what each bar of a particular color or pattern represents.

All replies

Imac, Mac OS X Posted on Apr 29, 2: Page content loaded. Apr 29, 3: Apr 29, 7: May 6, 1: May 19, 4: Setting first column as x-axis in chart More Less.

how to change the value of x -axis on the excel graph

Communities Contact Support. Sign in. Browse Search. Ask a question.


  • download mac os x version 10.6.7.
  • Re: how to change the value of x -axis on the excel graph.
  • age of empires iii the warchiefs download mac?
  • ERC Tweets.
  • Account Options?
  • Mac Excel - How to add Data Labels for Scatter Plot coming from 3rd column (Label, X, Y).
  • User profile for user: Geoff Brown Geoff Brown. Mac OS X Speciality level out of ten: From the Scale tab, under Interval Between Labels you can change the scale from 1 to 2 and every other label will be shown.

    X-Labels on Excel for Mac

    Change it to 5 and only 2 of the labels will be shown e. You can alter the appearance of tick types under the Ticks tab by choosing an option under Major tick mark type. It is also useful to know how to change the location of the axis labels. High will move the axis labels above the plot area.

    Apple Footer

    If the axis is not at the bottom of the plot area e. In this example, because the axis is at the bottom of the plot area, Low and Next to Axis will be the same.

    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. As with the horizontal axis there is a dialogue box for modifying the vertical axis.

    How to Add Axis Labels and Titles to Charts in Excel @ jammer(six)

    To get to it, double click on the vertical axis and the Format Axis dialogue box will appear. Remember that the axis is overlaid on the chart area, so make sure you are actually on the axis when you click. You can tell when the axis is selected because light blue dots will appear on the corners. Alternatively, you can reach this dialogue box by going to the Format tab or the Layout tab under the Charts toolbar and selecting Vertical Value Axis from the dropdown menu found at the top of the Current Selection group far left of the Ribbon.

    Then select Format Selection.

    label x and y axis in excel 2008 mac Label x and y axis in excel 2008 mac
    label x and y axis in excel 2008 mac Label x and y axis in excel 2008 mac
    label x and y axis in excel 2008 mac Label x and y axis in excel 2008 mac
    label x and y axis in excel 2008 mac Label x and y axis in excel 2008 mac
    label x and y axis in excel 2008 mac Label x and y axis in excel 2008 mac

Related label x and y axis in excel 2008 mac



Copyright 2019 - All Right Reserved