ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   x axis cut off on an Excel 2002 scatter chart (https://www.excelbanter.com/charts-charting-excel/42806-x-axis-cut-off-excel-2002-scatter-chart.html)

Geenie

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



JethroUK©

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


"Geenie" wrote in message
...
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





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" wrote in message
...
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






Jon Peltier

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" wrote in message
...

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






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" wrote in message
...

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








All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com