Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 04-20-2009, 02:38 PM
Beeblebrox Beeblebrox is offline
Registered User
 
Join Date: 10 Aug 2006
Location: Oakland
Posts: 32
Beeblebrox is becoming part of the community
Excel chart missing bottom border in Word

Please Register to Remove these Ads

When I cut and paste an Excel 2007 chart into Word 2007, on some types of charts the bottom border is not there. any ideas on how to fix this?
Reply With Quote
  #2  
Old 04-21-2009, 07:10 AM
ExlGuru's Avatar
ExlGuru ExlGuru is offline
Forum Administrator
 
Join Date: 17 Mar 2009
Location: India
MS Office Version:2003,2007
Posts: 222
ExlGuru is becoming part of the community
Re: Excel chart missing bottom border in Word

Can you please explain in brief what type of problems you are facing.I mean to say
"some types of charts the bottom border is not there. "

What exactly is not seen there?
please give some more information.
__________________
ExlGuru
Reply With Quote
  #3  
Old 04-21-2009, 12:47 PM
Beeblebrox Beeblebrox is offline
Registered User
 
Join Date: 10 Aug 2006
Location: Oakland
Posts: 32
Beeblebrox is becoming part of the community
Re: Excel chart missing bottom border in Word

I create a chart in Excel 2007. I do not add any special borders, just use the default ones. I click on the chart and cntrl-c. then go to Word 2007 and cntrl-v. the chart then looks ok except there is a thin black border on the two side and the top but not on the bottom. Some charts are ok and have all 4 borders but some do not. For the ones without the bottom border, i have also tried adjusting the axis title size and the chart area size, but that doesn't fix it.
Reply With Quote
  #4  
Old 04-23-2009, 02:53 AM
ExlGuru's Avatar
ExlGuru ExlGuru is offline
Forum Administrator
 
Join Date: 17 Mar 2009
Location: India
MS Office Version:2003,2007
Posts: 222
ExlGuru is becoming part of the community
Re: Excel chart missing bottom border in Word

It May be occur due to some settings.You just try to copy and paste again and let let me know if the same problem comes.Bcoz as i try to do this i did not face any problem with that.So once try again on the new word document.
__________________
ExlGuru
Reply With Quote
  #5  
Old 04-23-2009, 03:24 PM
Beeblebrox Beeblebrox is offline
Registered User
 
Join Date: 10 Aug 2006
Location: Oakland
Posts: 32
Beeblebrox is becoming part of the community
Re: Excel chart missing bottom border in Word

It's very inconsistent. I took the chart without the bottom border in the word document and copied it to a new doc. no bottom border. I changed the chart type in the original doc several differen ways and in some cases the border was there and in some cases it wasn't. e.g. not on bar charts but it was there on line and pie charts.

I changed the original bar chart to a line chart in the original doc and there was not bottom border, but when i copied it to a new doc, the border was there.
Reply With Quote
  #6  
Old 06-04-2009, 08:34 PM
ShadowBlight ShadowBlight is offline
Registered User
 
Join Date: 04 Jun 2009
Location: New Mexico, USA
MS Office Version:Excel 2007
Posts: 1
ShadowBlight is becoming part of the community
Re: Excel chart missing bottom border in Word

In Word 2007, you can fix the problem you have by modifying the text spacing before and after the line. In your case, changing the text spacing on the bottom of the line to 6pt should fix the chart from being cut off.
Reply With Quote
  #7  
Old 06-05-2009, 12:36 PM
Beeblebrox Beeblebrox is offline
Registered User
 
Join Date: 10 Aug 2006
Location: Oakland
Posts: 32
Beeblebrox is becoming part of the community
Re: Excel chart missing bottom border in Word

Great. It works. Thanks
Reply With Quote
  #8  
Old 09-30-2009, 02:27 PM
Tiatrack Tiatrack is offline
Registered User
 
Join Date: 30 Sep 2009
Location: Portland, OR
MS Office Version:Excel 2007
Posts: 1
Tiatrack is becoming part of the community
Re: Excel chart missing bottom border in Word

I am having this exact same problem, and it is so frustrating! It won't even let me add in a bottom line "post-hoc." I tried modifying the text size (I'm assuming that meant in the Word document?) and it didn't work. Any other ideas? Thanks!
Reply With Quote
  #9  
Old 09-30-2009, 04:18 PM
Beeblebrox Beeblebrox is offline
Registered User
 
Join Date: 10 Aug 2006
Location: Oakland
Posts: 32
Beeblebrox is becoming part of the community
Re: Excel chart missing bottom border in Word

I can't remember what i did now to fix it. But try changing both the font and font size in Word. try Arial.
Reply With Quote
  #10  
Old 11-06-2009, 01:33 PM
salokcin salokcin is offline
Registered User
 
Join Date: 06 Nov 2009
Location: Vancouver, Canada
MS Office Version:Excel 2007
Posts: 1
salokcin is becoming part of the community
Re: Excel chart missing bottom border in Word

Click on the last line that your chart appears on in the word file. The cursor should appear beside the chart at the bottom right. Go to the "page layout" tab (or right click and select "paragraph"), and set 'after' spacing to 6pt. If you are using Times New Roman, this should work. If it does not work, try increasing the number.
Reply With Quote
  #11  
Old 01-15-2010, 12:34 PM
tkisha tkisha is offline
Registered User
 
Join Date: 15 Jan 2010
Location: Pullman, WA
MS Office Version:Excel 2007
Posts: 2
tkisha is becoming part of the community
Re: Excel chart missing bottom border in Word

Quote:
Originally Posted by salokcin View Post
Click on the last line that your chart appears on in the word file. The cursor should appear beside the chart at the bottom right. Go to the "page layout" tab (or right click and select "paragraph"), and set 'after' spacing to 6pt. If you are using Times New Roman, this should work. If it does not work, try increasing the number.
This is also happening in Power Point. When I copy and paste a file from excel into a power point slide, the bottom border is not there. Very frustrating.
Reply With Quote
  #12  
Old 01-15-2010, 02:13 PM
tkisha tkisha is offline
Registered User
 
Join Date: 15 Jan 2010
Location: Pullman, WA
MS Office Version:Excel 2007
Posts: 2
tkisha is becoming part of the community
Re: Excel chart missing bottom border in Word

I saw on another forum that changing the border size to > 1.5 pts solved the problem. It worked for me in powerpoint.
Reply With Quote
  #13  
Old 01-16-2010, 11:30 PM
teylyn's Avatar
teylyn teylyn is online now
Forum Moderator
 
Join Date: 28 Oct 2008
Location: German in New Zealand
MS Office Version:2000 - 2010
Posts: 4,704
teylyn makes giving solutions look like childsplay teylyn makes giving solutions look like childsplay teylyn makes giving solutions look like childsplay teylyn makes giving solutions look like childsplay teylyn makes giving solutions look like childsplay teylyn makes giving solutions look like childsplay teylyn makes giving solutions look like childsplay teylyn makes giving solutions look like childsplay teylyn makes giving solutions look like childsplay
Re: Excel chart missing bottom border in Word

tkisha,

welcome to the forum. However ...

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
__________________
teylyn
If you want to say Thank you to a member, click the reputation icon in the title bar of the post you liked
Everyone needs a pat on the back every once in a while!
...How to Cross-post politely...
Things I do with the right side of my brain ...
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Forum Jump