Are you doing anything to the default labels? Changing their
orientation, font, alignment, etc.? What version of XL are you using?
For that version, are you using a particular support release? Are the
labels truncated in the default chart that XL creates, or does that
happen after you make some change to the chart? If so, what change?
MVP MS Excel
Thank you for quick response.
"Tushar Mehta" <ng_p...@bigfoot.com> wrote in message
In XL2002, I created a chart with numbers in the 10 trillion range for
both x and y values. The XY Scatter chart looks fine. What is the
range of numbers you are using?
You mention that you add the chart as an object in the worksheet. What
does that mean? Are you referring to the last step in the Chart Wizard
or something else?
Also, AFAIK, there has never been a 'properties' tab in the Format Axis
dialog box. There's Pattern, Scale, Font, Number, and Alignment. What
MSKB article are you referring to?
MVP MS Excel
In <7fTQ7.251086$ez.35...@news1.rdc1.nj.home.com>, M Van Kirk
Your second point is correct. It is the last step in the chart wizard where
the choice is create the chart as an object or entirely new sheet. I need
it as an object inorder to paste it in MS Word.
Q214332 is one of the MS knowledge base articles I read. I can not seem to
duplicate this in XK2002.
Thanks for all your time and effort.
My colleague is using the same and does not have this
problem. i too did not have this problem until my
computer crashed recently and everything had to be re-
loaded. i have tried to ensure that all of my display
settings are the same as my colleagues. this problem does
not occur with the very same file on his machine.
i do not know what is making the difference here, between
his and mine (and my old system). i've been using xl for
a very long time and have never come across this. i have
tried changing all settings available for axis labels and
display - i fear it runs deeper than this.
hope this info helps anyone who can help out - i too have
wasted far too much time on this.
Personally, I suspect I didn't run into the problem earlier, in spite of
the large number of charts I create, is twofold. First, I never use
axis labels. Instead, I use text boxes -- have for many years now. A
text box gives me, IMO, better control over the formatting and spacing.
Second, most of my printing is in Word, after I copy the XL chart into
the Word document ;-)
Anyway, here are some options (again after very little testing):
(1) Minimize the problem by putting the label contents on two lines.
For example, create a y-axis label with any text. Then, replace it:
enter 'annualized return' (w/o the quotes), then SHIFT-RETURN, then 'on
(2) Make the font size small, say 8 pt. Then, when XL enlarges it for
printing, it is still not too large.
(3) Use a text box. In a text box, move to the next line with CTRL-
MVP MS Excel
In <SF2R7.252310$ez.35...@news1.rdc1.nj.home.com>, M Van Kirk
The above tested with XL2000SR1 and XL2002.