Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Graphics
Here is my problem: I have a database comprised of 4 colums and want t
automate the creation of a graphic. Automating the graphic is fine ( have done that already) but what I want to do is (as shown on th attached graphic) is to create a text box with an attached line goin down to the actual date on the graphic. In that text box, I want th "Recommendation" and "Target" and the "date" to appear.. So basically, a code that would tell the program 1) build the graphi using the dates as the "x" and the prices as the "y". (that I have don already). 2) Search the Recommendation columm and when ever you come across a entry, create a text box in the graphic that has the date recommendation and target in it AND create an arrow pointing down t the same "date" on the graphic line....as shown in the attache file..... 3) I will be adding new data from time to time to update the graphics so the text boxes must move with the graphic (so that the arrows stil point to the correct date on the graphic line as I add new data..... I know this seems complicated (at least for me) but any help would b appreciated..... I could probably do most of it if: someone could tell me the code fo the program to search the recommendation collumm and create a text bo in the graph 2) how to lock the text boxes so that they move with th graphic as I enter new data.... Thank you very much for any hel Attachment filename: test-macro.xls Download attachment: http://www.excelforum.com/attachment.php?postid=40145 -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel graphics | New Users to Excel | |||
Excel Graphics | Charts and Charting in Excel | |||
Help with graphics in Excel Chart | Excel Discussion (Misc queries) | |||
how can I personalize more my graphics in Excel? | Excel Discussion (Misc queries) | |||
Cannot see graphics in Excel spreadsheet | Excel Discussion (Misc queries) |