| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Entering Line Breaks in a Title derived by a formula
I'm using the below formula for my title:
='Source Data'!$I$1:$I$3 I would like to put a line break after each cell it's pulling from. Is there a way to do this, or what is the best way to pull this data into the chart title so that I can get 3 lines of text? -- Scott |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Entering Line Breaks in a Title derived by a formula
In another cell enter a formula with line breaks:
='Source Data'!$I$1&CHAR(10)&'Source Data'!$I$2&CHAR(10)&'Source Data'!$I$3 Use this cell as the link for the title. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Scott" wrote in message ... I'm using the below formula for my title: ='Source Data'!$I$1:$I$3 I would like to put a line break after each cell it's pulling from. Is there a way to do this, or what is the best way to pull this data into the chart title so that I can get 3 lines of text? -- Scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting line breaks in text formula | Excel Discussion (Misc queries) | |||
| Line breaks | Excel Discussion (Misc queries) | |||
| unexpected line breaks in .csv | Excel Discussion (Misc queries) | |||
| How do I copy cell values (derived from formula), not references? | Excel Worksheet Functions | |||
| Line breaks | Excel Worksheet Functions | |||
Hybrid Mode
