Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Tick Mark Label
I'm making a bar chart showing the returns of quarter, 9 month 1 year 5 year
since Inception. The returns of current year are negative i have my tick mark labels just below the axis...is there any way possible making the first 3 label above the axis so the bar will not block the label? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Tick Mark Label
Hi,
You can change the position of the axis labels but it will affect all of them. Double click the axis and choose the Low option for Tick Labels position. If you really must have some above and some below then you can mimic the axis labels with additional series and data labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "funkev123" wrote in message ... I'm making a bar chart showing the returns of quarter, 9 month 1 year 5 year since Inception. The returns of current year are negative i have my tick mark labels just below the axis...is there any way possible making the first 3 label above the axis so the bar will not block the label? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Tick Mark Label
Hi,
I'm not sure I have this one clear, are you using a Column or a Bar chart? If you are using a Bar, there is no command to put the Tick Mark labels "below", there is a command to put the Tick Mark Labels "Low". In that case the Tick mark labels do not overlap the bars unless you force the X-axis minimum. One additional thing you can do with a bar chart is double-click the Y-axis and choose the Alignment tab and set the Offset value to a larger number. -- Thanks, Shane Devenshire "funkev123" wrote: I'm making a bar chart showing the returns of quarter, 9 month 1 year 5 year since Inception. The returns of current year are negative i have my tick mark labels just below the axis...is there any way possible making the first 3 label above the axis so the bar will not block the label? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
not able to see tick mark label | Charts and Charting in Excel | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
showing start of each month as tick mark & label on X-Y chart | Charts and Charting in Excel | |||
X axis tick mark over label | Charts and Charting in Excel | |||
Tick Mark Label Line Wrap | Charts and Charting in Excel |