![]() |
|
|
|
#1
|
|||
|
|||
|
Hello,
Please have a look at the graph below: ![]() How can I change the position of the horizontal axis labels (i.e. Jan, Feb, Mar,...). They are overlapping with the bars and I think it would look cleaner if they were in a clear area, like above the bars. When I hover over it, a box highlights around it and the mouse cursor transforms into a four-way set of arrows, but when I click and drag, nothing happens. |
|
#2
|
|||
|
|||
|
Click on horizontal axis - label area will be activated;
Richt-click on border of label area and select Format Axis from drop-down menu; Expand LABELS group, and set Label Position to low. |
|
#3
|
|||
|
|||
|
Thanks Arvi, that works. Except you can't move the labels above the horizontal axis.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pre-set visible horizontal axis | UHD | PowerPoint | 0 | 10-04-2017 06:58 AM |
| my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. | jalea148 | Excel | 3 | 01-06-2017 09:04 AM |
| Graph Assistance: How to display numbers for horizontal axis items | awoitte | Word | 0 | 11-10-2016 09:46 AM |
Select which labels to display on horizontal axis on line chart
|
Jack H | Excel | 5 | 01-13-2016 10:05 AM |
column clustered bar graph with a line graph as secondary axis
|
Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |