Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Geenie
 
Posts: n/a
Default 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


  #2   Report Post  
JethroUK©
 
Posts: n/a
Default

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




  #3   Report Post  
Geenie
 
Posts: n/a
Default

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





  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

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





  #5   Report Post  
Geenie
 
Posts: n/a
Default

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Add-in: Open Database Connectivity available for Excel Nick B Excel Discussion (Misc queries) 8 December 7th 06 06:04 PM
Scatter Chart Axis as text in C# Web appl Pavr1 Charts and Charting in Excel 1 March 31st 05 05:28 AM
Scatter Chart Axis as text C# Pablo Villalobos via OfficeKB.com Charts and Charting in Excel 1 March 18th 05 10:10 PM
Controlling excel chart axis Rain Charts and Charting in Excel 1 January 20th 05 01:15 AM
the dates to label the x axis on the scatter chart won't print waterlady Charts and Charting in Excel 0 November 29th 04 06:44 PM


All times are GMT +1. The time now is 06:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"