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
|
|||
|
|||
textbox position
I am adding textboxes to a line chart. Is there anyway to add a textbox
(VBA?) using my chart xy coordinates? 01/02/2006 300 01/03/2006 400 01/05/2006 900 01/06/2006 300 01/07/2006 350 I would like to center a textbox at (01/05/2006,900) with "downtime" as the text. I don't want to add a texbox and manually position it. I tried using the xychartlabeler (works great) but I need the ability to add several lines of text with different colors. |
#2
|
|||
|
|||
textbox position
Use the chart labeler. Every differently formatted item can be put into its
own label (different colors in different labels). I do this all the time, and everyone thinks it's magic. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Mona" wrote in message ... I am adding textboxes to a line chart. Is there anyway to add a textbox (VBA?) using my chart xy coordinates? 01/02/2006 300 01/03/2006 400 01/05/2006 900 01/06/2006 300 01/07/2006 350 I would like to center a textbox at (01/05/2006,900) with "downtime" as the text. I don't want to add a texbox and manually position it. I tried using the xychartlabeler (works great) but I need the ability to add several lines of text with different colors. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ComboBox RowSource Disappears | Larry | Using Forms | 3 | December 8th, 2005 03:27 AM |
using word, is there any way to lock a textbox into position | Chrisl26 | Page Layout | 1 | November 30th, 2005 02:24 PM |
Accurate position for a textbox | Roger Frans | Setting Up & Running Reports | 4 | October 24th, 2005 08:46 PM |
Accurate position for a textbox | Roger Frans | Setting Up & Running Reports | 0 | October 22nd, 2005 08:11 PM |
Textbox moves position when Printing? | Rugdoody | General Discussion | 1 | September 21st, 2005 09:42 PM |