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
|
|||
|
|||
How to I write text onto connectors/lines in Excel?
I want to draw a decision tree flowchart in Excel.
Hence I need to write on the connector/line that links two boxes. e.g. I want to write 'YES' and 'NO' onto the connector/line. Is this possible? Thanks |
#2
|
|||
|
|||
How to I write text onto connectors/lines in Excel?
Hi,
It would appear you can not add text directly to a connection line. You will have to use a textbox. If you need the text and connector to move together you can group the shapes. Cheers Andy Umar wrote: I want to draw a decision tree flowchart in Excel. Hence I need to write on the connector/line that links two boxes. e.g. I want to write 'YES' and 'NO' onto the connector/line. Is this possible? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
How to I write text onto connectors/lines in Excel?
A few tips:
1. Like Andy said - use a textbox. 2. Right-click on the textbox, and select Format AutoShape. In the dialog that shows, select the Colors and Lines tab and set the border line to No Line. 3. Once you've formatted one textbox, click the Format Painter (paint brush symbol) button on the toolbar then click the second shape to copy the "no line" style. 4. If the flow lines (arrow connectors) show on top of the textbox, right-click the textbox and select Order Bring to front from the context menu. 5. When you're done, either disable the gridlines or set the fill color to white for the whole sheet. This will give the flowchart a cleaner look, and the white fill of the Yes/No textboxes will no longer stand out. HTH, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Feedback on table setup | Little Penny | Database Design | 1 | December 28th, 2005 11:32 AM |
Newbie Looking for Help | Little Penny | Using Forms | 6 | December 27th, 2005 08:33 PM |
Newbie table Layout (Posted as suggested by Tom Lake for feedback) | Little Penny | Using Forms | 2 | December 25th, 2005 04:44 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |