LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 837
Default Text boxes over charts

I have prepared a chart [XY (Scatter)] for a report, and labeled selected
regions of the chart with text boxes. When the chart is not selected, the
text boxes are visible, as desired. When I select the chart to copy and
paste into my Word document, the text boxes disappear.

I presume that the chart itself comes into the foreground with the text
boxes in the background, but I have not found any acceptable way to make the
text boxes show up on the chart in the Word document. I have looked at the
text box properties and cannot find any option that would make them always on
top. The chart options do not include anything that would make it
sufficiently transparent so that the text boxes would still be visible when
the chart is selected. The picture editor in Word messes up the chart
unacceptably.

The one kludge that sort of works is to paste the graph into Word, then
copy/paste each text box as an individual enhanced meta file picture, and
anchor them to the Word paragraph that contains the graph so that they at
least move with the graph as I edit the report.

Is there a better way?

Jerry
 
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
How to convert a month to a quarter ...... Epinn New Users to Excel 26 May 3rd 23 07:45 PM
printing a worksheet with VB buttons or text boxes Pauline Excel Discussion (Misc queries) 1 September 15th 06 01:18 AM
Text boxes Excel 2003 change position in print preview James McCann Charts and Charting in Excel 1 March 26th 06 11:51 PM
Linked/dynamic Chart titles, text boxes etc... e18 Excel Discussion (Misc queries) 3 March 17th 06 09:45 AM
Linked cells and text boxes Alexlondon11 Excel Discussion (Misc queries) 2 November 23rd 05 04:10 PM


All times are GMT +1. The time now is 10:37 PM.

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

About Us

"It's about Microsoft Excel"