Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text box that contains a range of cells not just one.
I am trying to create a text box in a chart that contains a range of cells.
I ahve seen this on a chart but cannot don't understand how it was done. Every time I try I can only enter one cell. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text box that contains a range of cells not just one.
Hi,
You can only link to one cell so you need to concatenate the cells in another cell and then link to that. Cheers Andy Chili Don wrote: I am trying to create a text box in a chart that contains a range of cells. I ahve seen this on a chart but cannot don't understand how it was done. Every time I try I can only enter one cell. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete text to right of a comma in a range of cells? | Excel Discussion (Misc queries) | |||
How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Linked cells and text boxes | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel |