If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text boxes
Checked the z-order of the respective objects?
-- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , Bourbon says... I have code that creates a graphic and text boxes automatically. But when I try add drag the text box over the graphic its is masked by the graph and does not go "on top of it". I don't understand why because when I manually draw a text box and drag it over the graph it shows? I checked the properties and they are the same. WHat could be worng? Thanks B. --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Text boxes
If you want the textbox incorporated into the chart, select the chart
before drawing the textbox. Or select the chart, then start typing, and your text will be placed into a textbox. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Bourbon wrote: I have code that creates a graphic and text boxes automatically. But when I try add drag the text box over the graphic its is masked by the graph and does not go "on top of it". I don't understand why because when I manually draw a text box and drag it over the graph it shows? I checked the properties and they are the same. WHat could be worng? Thanks B. --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
Text boxes
That is great Jon, thanks. But I am still perplexed. My program does the
following: I have 4 columms of data (Dates, stock prices, recommendations, target price):1) It graphs the Dates and stock price columms, 2) when it finds data in the Recommendations columm, it creates a text box in the 5th columm (E), next to the target price columm (D). Thus my text boxes are created automatically and so is my graph... The next part is that I will write a code so that columms A,C and D are copied and pasted into the preexisting text boxes when ever a text box is present and then dragged into the graphic (just below the title, so each text box is side by side and a line will be drawn pointing down to the corresponding dates on the graph line).. 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???? This has me very confused! I was thinking of your suggestion to simply copy and paste directly into the graph and it will automatically create a text box but 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.....Do you know how I can select the data inside 3 different cells simultaneously (a kind of Ctrl-C but that will select the data and not the entier cell).. This is a very long question but it has me very confused and &?&%?$&*%%$............ Thanks again Jon B. --- Message posted from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
Text boxes
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 the text boxes are there first, the chart is drawn on top of them. If the text box is drawn later, it is on top. You can use the Bring to Front and Send to Back buttons under the drawing command bar hierarchy to adjust the Z order. But it's better to have the text boxes in the chart, so if the chart is moved, the text boxes don't stay put. You have to draw them one at a time, you can't make multiple textboxes all at once. To put the content of multiple cells into a single text box, you could concatenate them into another textbox first. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Bourbon wrote: That is great Jon, thanks. But I am still perplexed. My program does the following: I have 4 columms of data (Dates, stock prices, recommendations, target price):1) It graphs the Dates and stock price columms, 2) when it finds data in the Recommendations columm, it creates a text box in the 5th columm (E), next to the target price columm (D). Thus my text boxes are created automatically and so is my graph... The next part is that I will write a code so that columms A,C and D are copied and pasted into the preexisting text boxes when ever a text box is present and then dragged into the graphic (just below the title, so each text box is side by side and a line will be drawn pointing down to the corresponding dates on the graph line).. 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???? This has me very confused! I was thinking of your suggestion to simply copy and paste directly into the graph and it will automatically create a text box but 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.....Do you know how I can select the data inside 3 different cells simultaneously (a kind of Ctrl-C but that will select the data and not the entier cell).. This is a very long question but it has me very confused and &?&%?$&*%%$............ Thanks again Jon B. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|