sponsored ads

how to add axis label excel 2010

sponsored ads

 I mad a chart in excel 2010 and i want to add axis label to it. How can i achieve it? Thanks to all who respond!

 
Asked Oct, 30 2010
add commentflag 

sponsored ads

answer this question

1 answers

  • 1

    Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart to which you would like to add an axis title.

  • 2

    Select the entire Excel chart by clicking in the white area of the chart. A light blue line will surround the entire chart indicating it has been selected.

  • 3

    Choose the "Layout" tab at the top of the Excel screen and locate the "Labels" group within the "Layout" ribbon.

  • 4

    Click the "Axis Titles" button in the "Labels" section of the "Layout" ribbon to display a drop-down list.

  • 5

    Point to "Primary Horizontal Axis Title" to create a title for your "X"-axis or point to "Primary Vertical Axis Title" to create a title for your "Y"-axis.

  • 6

    Click to choose where you want the selected title to be displayed in relation to the rest of the chart. The selections you see will depend on how your chart is formatted. A default title for the chart will appear the in the location you have chosen.

  • 7

    Add your own title by clicking on the default title and typing your new title with your keyboard. Press the "Enter" key when you are finished typing the title.


Answered Oct, 30 2010
add comment|flag 
vote up 0 vote down
check

As I know ,3-D charts have a third axis, the depth (z) axis, so that data can be plotted along the depth of a chart. Pie and doughnut charts do not have any axes.
I hope this may help. Answered Dec, 19 2010
vote up 1 vote down

  • 1

    Start Microsoft Excel 2010 and open a spreadsheet from your files that contains a chart to which you would like to add an axis title.

  • 2

    Select the entire Excel chart by clicking in the white area of the chart. A light blue line will surround the entire chart indicating it has been selected.

  • 3

    Choose the "Layout" tab at the top of the Excel screen and locate the "Labels" group within the "Layout" ribbon.

  • 4

    Click the "Axis Titles" button in the "Labels" section of the "Layout" ribbon to display a drop-down list.

  • 5

    Point to "Primary Horizontal Axis Title" to create a title for your "X"-axis or point to "Primary Vertical Axis Title" to create a title for your "Y"-axis.

Answered Nov, 23 2010
vote up 0 vote down

  • 1

    Start Microsoft Excel 2010 and open a spreadsheet from your files that contains a chart to which you would like to add an axis title.

  • 2

    Select the entire Excel chart by clicking in the white area of the chart. A light blue line will surround the entire chart indicating it has been selected.

  • 3

    Choose the "Layout" tab at the top of the Excel screen and locate the "Labels" group within the "Layout" ribbon.

  • 4

    Click the "Axis Titles" button in the "Labels" section of the "Layout" ribbon to display a drop-down list.

  • 5

    Point to "Primary Horizontal Axis Title" to create a title for your "X"-axis or point to "Primary Vertical Axis Title" to create a title for your "Y"-axis.

  • 6

    Click to choose where you want the selected title to be displayed in relation to the rest of the chart. The selections you see will depend on how your chart is formatted. A default title for the chart will appear the in the location you have chosen.

  • 7

    Add your own title by clicking on the default title and typing your new title with your keyboard. Press the "Enter" key when you are finished typing the title.

    view you the webpage:http://blogs.msdn.com/b/excel/archive/2007/08/24/combining-chart-types-adding-a-second-axis.aspx. I hope it can be helpful

Answered Nov, 11 2010
vote up 1 vote down

Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
Create one

Options

sponsored ads

Download related software from AFC

Label Xpress 2.0 Release 1

Last Updated: Nov 8, 2011
License: Freeware
Filesize: 4.35MB

Continue to downloadPower by Afreecodec.com