Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Text line spacing in Excel Chart
I've built a pivot Chart and the spacing of the Axis labels and legend have
what appear to be a paragraph spacing before and between. The axis labels actually lie below the text box for the axis. How do I remove the line spacing before and between text? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Text line spacing in Excel Chart
Hi John,
I'm not really sure what you are after but if a cell contains a hard return (Alt+Enter) then the chart item referencing that cell will also display on multiple lines. In the spreadsheet you can remove hard returns by backspacing or deleting them out manually or you can sometimes use the function =CLEAN(A1) where A1 contains the problems. If CLEAN doesn't work you can sometimes use SUSTITUTE, but that means that you need to determine what hidden character is causing the problem. To do that you can use CODE or you can just copy and paste the character into the SUBSTITUTE function. Cheers, Shane Devenshire Microsoft Excel MVP "John B" wrote in message ... I've built a pivot Chart and the spacing of the Axis labels and legend have what appear to be a paragraph spacing before and between. The axis labels actually lie below the text box for the axis. How do I remove the line spacing before and between text? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change line spacing of text in Excel cells | Excel Discussion (Misc queries) | |||
how to change line spacing for text box in excel chart | Charts and Charting in Excel | |||
Legend Line Spacing | Charts and Charting in Excel | |||
double line spacing using excel 2000 | Excel Discussion (Misc queries) | |||
Bulleting text and spacing down a line in Excel | Excel Discussion (Misc queries) |