Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with line OLE objects
Hi,
I work with Excel to calculate some charts and tables that are copie and pasted to a PowerPoint with the automation. One of the parts of these reports is to show an upward arrow whe results grow significantly and arrow down when it falls for eac element in the table. I done this putting two visible arrows line objects in every row of th table. Then the formula checks the results and accordingly hid unneeded arrows using visible=false. (please see the workshee attached, no code attached). It works fine apart from one issue - I find it difficult to work wit line OLE objects. I try to do it using the name "Line_xx", where xx i a number. Unfortunately numbers easily change if I modify the workbook Moreover if I copy attached worksheet to another workbook lines wil also change the numbering. On the other hand I have to know what is th number of the particular line as sometimes the calculation vary betwee factors. I feel there must be an easy solution somehow I can't see. I'l be ver thankful for any ideas. Thanks a lot, Micha Attachment filename: arrows.xls Download attachment: http://www.excelforum.com/attachment.php?postid=56239 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with line OLE objects
Michal
Try naming the lines explicitly, eg. "mLine_xx" ie. select a line then enter its new name into the Name Box Kevin Beckham -----Original Message----- Hi, I work with Excel to calculate some charts and tables that are copied and pasted to a PowerPoint with the automation. One of the parts of these reports is to show an upward arrow when results grow significantly and arrow down when it falls for each element in the table. I done this putting two visible arrows line objects in every row of the table. Then the formula checks the results and accordingly hide unneeded arrows using visible=false. (please see the worksheet attached, no code attached). It works fine apart from one issue - I find it difficult to work with line OLE objects. I try to do it using the name "Line_xx", where xx is a number. Unfortunately numbers easily change if I modify the workbook. Moreover if I copy attached worksheet to another workbook lines will also change the numbering. On the other hand I have to know what is the number of the particular line as sometimes the calculation vary between factors. I feel there must be an easy solution somehow I can't see. I'l be very thankful for any ideas. Thanks a lot, Michal Attachment filename: arrows.xls Download attachment: http://www.excelforum.com/attachment.php?postid=562396 --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gradient Line Chart not Working | Charts and Charting in Excel | |||
Line objects not printing | Excel Discussion (Misc queries) | |||
Highlight line working on. | Excel Discussion (Misc queries) | |||
change the default setting of the line of objects. .75 to 2. | Excel Discussion (Misc queries) | |||
right click on objects not working | Excel Discussion (Misc queries) |