Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Labelling X and Y axis

I cannot label the X and Y axis in Excel. I would be grateful if any one
would help.
--
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default Labelling X and Y axis


In EXCEL 2007 take the following action:-

1. Click somewhere in the graph.

2. Chart Tools / Layout / Labels group / Axis Titles / Primary Horizontal
Axis Title / Title Below Axis

3. A box will now be placed on the X axis. Just click in the box to edit it
then click anywhere outside of the box to see the effect of the change that
you have just made.

4. Click somewhere in the graph.

5. Chart Tools / Layout / Labels group / Axis Titles / Primary Vertical Axis
Title / Horizontal Title

6. A box will now be placed on the Y axis. Just click in the box to edit it
then click anywhere outside of the box to see the effect of the change that
you have just made.

Save the file if required.

Please hit Yes if my comments have helped,

Thanks.



"ecp1rm" wrote:

I cannot label the X and Y axis in Excel. I would be grateful if any one
would help.
--
Thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default Labelling X and Y axis

Just in case you mean Data Labels (these are descriptions that, for example,
appear above the actual columns on the graph itself) take the following
action in EXCEL 2007:-

1. Click on the chart to highlight it.

2. Chart Tools / Layout / Labels group / Data Labels / Outside End

This will place the Data Labels (for example numbers) above the columns in
the chart that you have.

Please hit Yes if my comments have helped,

Thanks.



"ecp1rm" wrote:

I cannot label the X and Y axis in Excel. I would be grateful if any one
would help.
--
Thanks

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default Labelling X and Y axis

And finally . . .

If you want to take a look at:-

http://www.pierrefondes.com/

Item number 28 towards the top of my home page (at the very top at the
moment) there is an EXCEL 2007 file in which you can see what I have done.

The chart on my website does not show the addition of the Data Labels.

You can practise that yourself by taking the aforementioned actions:-

1. Click on the chart to highlight it.

2. Chart Tools / Layout / Labels group / Data Labels / Outside End

This will place the Data Labels (for example numbers) above the columns in
the chart that you have.

Please hit Yes if my comments have helped,

Thanks.



"ecp1rm" wrote:

I cannot label the X and Y axis in Excel. I would be grateful if any one
would help.
--
Thanks

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Labelling X and Y axis

Chart menu/ Chart Options/ Titles.
--
David Biddulph

ecp1rm wrote:
I cannot label the X and Y axis in Excel. I would be grateful if any
one would help.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 chart line width + axis labelling with VBA HB[_2_] Charts and Charting in Excel 6 August 25th 09 01:01 AM
x-axis labelling - how to put it above the axis? Got new job, but with old Excel! Charts and Charting in Excel 8 January 31st 07 11:27 AM
Bar chart x axis labelling JRD Charts and Charting in Excel 1 December 20th 06 01:21 PM
Excel 2003, graph y axis labelling problem Dave Berry, United Kingdom Charts and Charting in Excel 1 April 5th 06 06:40 PM
Labelling bar graph-the bars in X-axis not via tthe legend MikeR-Oz New Users to Excel 2 January 3rd 06 10:26 PM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"