Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |