Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 15th 09, 11:57 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 1
Default How to hide a chart title, but keep the title in the chart

Using Excel 2003, I am creating charts and linking them to a word document.
I'd like to give each chart a title in Excel, then in Word, bring down the
top border to "cover" or exclude the title so it doesn't show in the Word
document. That way, later I can reopen the top border to remember the title
I gave it and where it came from in my Excel spreadsheet.

Right now each time I try to mouse-drag the top border, the chart size and
shape change, but all the info remains and just gets squished down. I want
the chart to remain "stable" so I can cover over the title.

I know I could do this at one time. Who knows what I need to do?

  #2   Report Post  
Old July 16th 09, 12:13 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 461
Default How to hide a chart title, but keep the title in the chart

You can right click on the pasted chart in Word, and select Show Picture
Toolbar. Now use the Crop tool on this toolbar to hide the edges of the
chart. This works with an embedded chart, and even better with a chart
that's been pasted as a picture.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



KBratt wrote:
Using Excel 2003, I am creating charts and linking them to a word document.
I'd like to give each chart a title in Excel, then in Word, bring down the
top border to "cover" or exclude the title so it doesn't show in the Word
document. That way, later I can reopen the top border to remember the title
I gave it and where it came from in my Excel spreadsheet.

Right now each time I try to mouse-drag the top border, the chart size and
shape change, but all the info remains and just gets squished down. I want
the chart to remain "stable" so I can cover over the title.

I know I could do this at one time. Who knows what I need to do?



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
Dynamic Chart Title With 3D Stacked Column Chart Thomas M. Charts and Charting in Excel 2 March 23rd 09 04:14 PM
second Chart Title Harold Good Charts and Charting in Excel 2 January 31st 08 04:59 PM
Chart title syssupspe Charts and Charting in Excel 1 September 11th 07 09:51 AM
Excel chart - how to assign the file name in the chart title? TGreen Charts and Charting in Excel 1 August 16th 05 10:35 AM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM


All times are GMT +1. The time now is 03:43 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017