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.
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.
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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.