Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
printing a worksheet with VB buttons or text boxes | Excel Discussion (Misc queries) | |||
Text boxes Excel 2003 change position in print preview | Charts and Charting in Excel | |||
Linked/dynamic Chart titles, text boxes etc... | Excel Discussion (Misc queries) | |||
Linked cells and text boxes | Excel Discussion (Misc queries) |