not able to see tick mark label

  • Thread starter Thread starter e57
  • Start date Start date
E

e57

I created a custom date-axis in the form N, D, J-YY, F,...
But -YY is not always visible even after I have shrunk the size of the
tick mark label.

Any suggestions would be greatly appreciated.
 
Sometimes I've seen the label wrap the text, so that the YY is on the next
line, but for some reason only the first line of the label is visible. I
seem to recall this happening on small charts with small fonts and a large
number of labels.

- Jon
 
I created a custom date-axis in the form N, D, J-YY, F,...
But -YY is not always visible even after I have shrunk the size of the
tick mark label.

Any suggestions would be greatly appreciated.
Click to expand...

Create a second date column in the worksheet, with the same date and the
format YY, and use both columns to make the date axis. This will
display correctly.
 
Create a second date column in the worksheet, with the same date and
the format YY, and use both columns to make the date axis. This will
display correctly.
Click to expand...

Correction: will display correctly in 97. Having just looked at it in
2000, I see that the "improvement" that forces double-columned category
ranges to look like those ugly Pivot Charts, with the combs cluttering
up the space.

So, plan B: go back to one column, format just the months you want with

"mmmmm yy" (space, not hyphen)

leaving the rest at "mmmmm".

Then set Chart Options.. Axes to "Category", and set Format Axis to
"Linked to source", then ensure that the months are packed too tightly
to allow the year to appear in the same line. It will wrap down to the
second line and appear as

J
08

which is how you want it.
 
If I were having trouble with the labels, I'd hide the default labels, then
plot a dummy series along the axis and assign data labels that achieve the
look I need.

- Jon
 
Back
Top