How to hide a chart title, but keep the title in the chart

K

KBratt

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?
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top