Text boxes-help

[Bourbon]

That is great Jon, thanks. But I am still perplexed. My program does th
following: I have 4 columms of data (Dates, stock prices
recommendations, target price):1) It graphs the Dates and stock pric
columms, 2) when it finds data in the Recommendations columm, i
creates a text box in the 5th columm (E), next to the target pric
columm (D). Thus my text boxes are created automatically and so is m
graph...

The next part is that I will write a code so that columms A,C and D ar
copied and pasted into the preexisting text boxes when ever a text bo
is present and then dragged into the graphic (just below the title, s
each text box is side by side and a line will be drawn pointing down t
the corresponding dates on the graph line)..

So now that you know what it is supposed to do, I really don'
understand why when I try to drag the text boxes onto the graphic, the
do not show and yet when I manually draw a text box outside the graphi
and drag it, it shows????

This has me very confused!

I was thinking of your suggestion to simply copy and paste directl
into the graph and it will automatically create a text box but th
problem is that I have 3 columms of data to copy and paste and am no
able to select all three at the same time and paste them into th
graphic simultaneously so they are all in only 1 text box.....Do yo
know how I can select the data inside 3 different cells simultaneousl
(a kind of Ctrl-C but that will select the data and not the entie
cell)..

This is a very long question but it has me very confused an
&?&%?$&*%%$............

Thanks again Jon
B

 

[Jon Peltier]

I think I answered this already, but I don't see the post.

So now that you know what it is supposed to do, I really don't
understand why when I try to drag the text boxes onto the graphic,
they do not show and yet when I manually draw a text box outside the
graphic and drag it, it shows????

If you drag a text box from anywhere over a chart, it is not part of the
chart, it is just floating in Excel's drawing layer above the worksheet,
the same layer where the chart floats. It might be above the chart or
below it, depending on which was created first, and whether you've used
the bring to front/send to back buttons. The one that was made before
the chart is underneath the chart, while the one you made after the
chart is above the chart. Such a textbox is not part of a chart, even if
it's visible on top of the chart. Move the chart, and the text box stays
where it was.

the problem is that I have 3 columms of data to copy and paste and am
not able to select all three at the same time and paste them into the
graphic simultaneously so they are all in only 1 text box.....

You need a copy and paste for each text box you want to put into the
chart. If you already have multiple text boxes in the sheet, you can
select and copy them all and paste them into the chart.

- Jon