#1
|
|||
|
|||
how to move horizontal axis labels on bar graph
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 |