x axis cut off on an Excel 2002 scatter chart

Good Morning...

When creating an XY Scatter chart, my x axis title gets cut off so not all
of the text is being displayed.

I found a Microsoft workaround that said to change the alignment to be 89%.
This gets an extra letter or two added in but not all of the text.

I am using OfficeXP with SP3 installed.

Has anyone seen this before?

Thanks for the help,
Geenie

XL doesn't always reflect font sizes correctly - what does it look like in
print?


"Geenie" <[email protected]> wrote in message
news:[email protected]...
> Good Morning...
>
> When creating an XY Scatter chart, my x axis title gets cut off so not all
> of the text is being displayed.
>
> I found a Microsoft workaround that said to change the alignment to be
89%.
> This gets an extra letter or two added in but not all of the text.
>
> I am using OfficeXP with SP3 installed.
>
> Has anyone seen this before?
>
> Thanks for the help,
> Geenie
>
>

It prints fine - all of the text is there.

The problem is when I copy the chart into Word and use it in reports.
Because all of the text isn't being displayed on the chart in Excel, when I
copy and paste into Word the text is also missing. I can't resize the text
box for the axis name either.

Thanks,
Geenie


"JethroUK©" wrote:

> XL doesn't always reflect font sizes correctly - what does it look like in
> print?
>
>
> "Geenie" <[email protected]> wrote in message
> news:[email protected]...
> > Good Morning...
> >
> > When creating an XY Scatter chart, my x axis title gets cut off so not all
> > of the text is being displayed.
> >
> > I found a Microsoft workaround that said to change the alignment to be
> 89%.
> > This gets an extra letter or two added in but not all of the text.
> >
> > I am using OfficeXP with SP3 installed.
> >
> > Has anyone seen this before?
> >
> > Thanks for the help,
> > Geenie
> >
> >
>
>
>

Try copying in Excel as a picture. Hold Shift while selecting the Edit
menu, and Copy becomes Copy Picture. Select the As Printed option (since
printing works), then just paste into Word.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Geenie wrote:
> It prints fine - all of the text is there.
>
> The problem is when I copy the chart into Word and use it in reports.
> Because all of the text isn't being displayed on the chart in Excel, when I
> copy and paste into Word the text is also missing. I can't resize the text
> box for the axis name either.
>
> Thanks,
> Geenie
>
>
> "JethroUK©" wrote:
>
>
>>XL doesn't always reflect font sizes correctly - what does it look like in
>>print?
>>
>>
>>"Geenie" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>Good Morning...
>>>
>>>When creating an XY Scatter chart, my x axis title gets cut off so not all
>>>of the text is being displayed.
>>>
>>>I found a Microsoft workaround that said to change the alignment to be
>>
>>89%.
>>
>>>This gets an extra letter or two added in but not all of the text.
>>>
>>>I am using OfficeXP with SP3 installed.
>>>
>>>Has anyone seen this before?
>>>
>>>Thanks for the help,
>>>Geenie
>>>
>>>
>>
>>
>>

Hi Jon:

I tried what you suggested and it worked. Thank you for the help!

Geenie

"Jon Peltier" wrote:

> Try copying in Excel as a picture. Hold Shift while selecting the Edit
> menu, and Copy becomes Copy Picture. Select the As Printed option (since
> printing works), then just paste into Word.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> Geenie wrote:
> > It prints fine - all of the text is there.
> >
> > The problem is when I copy the chart into Word and use it in reports.
> > Because all of the text isn't being displayed on the chart in Excel, when I
> > copy and paste into Word the text is also missing. I can't resize the text
> > box for the axis name either.
> >
> > Thanks,
> > Geenie
> >
> >
> > "JethroUK©" wrote:
> >
> >
> >>XL doesn't always reflect font sizes correctly - what does it look like in
> >>print?
> >>
> >>
> >>"Geenie" <[email protected]> wrote in message
> >>news:[email protected]...
> >>
> >>>Good Morning...
> >>>
> >>>When creating an XY Scatter chart, my x axis title gets cut off so not all
> >>>of the text is being displayed.
> >>>
> >>>I found a Microsoft workaround that said to change the alignment to be
> >>
> >>89%.
> >>
> >>>This gets an extra letter or two added in but not all of the text.
> >>>
> >>>I am using OfficeXP with SP3 installed.
> >>>
> >>>Has anyone seen this before?
> >>>
> >>>Thanks for the help,
> >>>Geenie
> >>>
> >>>
> >>
> >>
> >>
>