Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis tick mark over label
A client wants the x-axis tick mark label (bar chart) to be positioned under
the tick mark instead of between tick marks. We've managed to do this before but didn't write it down and now we can't remember. I've been trying every combination I can think of and nothing makes the tick mark label show under the tick mark. The Data Series options is at 0 so the bars touch on the sides and they want the labels to be between the two bars where they touch, which would be right under the major tick mark. Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis tick mark over label
Hi,
Double click the category axis and on the scale tab uncheck, Value (Y) axis crosses between categories. This will mean adding a dummy set of data to the begining and end of the data series otherwise you will loses 2 columns. Cheers Andy RoxSn wrote: A client wants the x-axis tick mark label (bar chart) to be positioned under the tick mark instead of between tick marks. We've managed to do this before but didn't write it down and now we can't remember. I've been trying every combination I can think of and nothing makes the tick mark label show under the tick mark. The Data Series options is at 0 so the bars touch on the sides and they want the labels to be between the two bars where they touch, which would be right under the major tick mark. Thanks! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis tick mark over label
Thank you! We probably tried that in combination with something else and
jumped right over using that single change. "Andy Pope" wrote: Hi, Double click the category axis and on the scale tab uncheck, Value (Y) axis crosses between categories. This will mean adding a dummy set of data to the begining and end of the data series otherwise you will loses 2 columns. Cheers Andy RoxSn wrote: A client wants the x-axis tick mark label (bar chart) to be positioned under the tick mark instead of between tick marks. We've managed to do this before but didn't write it down and now we can't remember. I've been trying every combination I can think of and nothing makes the tick mark label show under the tick mark. The Data Series options is at 0 so the bars touch on the sides and they want the labels to be between the two bars where they touch, which would be right under the major tick mark. Thanks! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
How to change tick mark labels in z axis from values to texts? | Charts and Charting in Excel | |||
Tick Mark Label Line Wrap | Charts and Charting in Excel | |||
Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
Scatter chart x axis tick mark lables | Charts and Charting in Excel |