ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Line break in X-axis column label? (https://www.excelbanter.com/charts-charting-excel/84882-line-break-x-axis-column-label.html)

Ed

Line break in X-axis column label?
 
I have a chart with the data shown in columns. I am trying to format my
data column in the worksheet so the column label on the X-axis has a line
break that makes sense. I want:
Run 1 -
1843 RPM
but I can't force a break after the hyphen in the worksheet, so I'm getting
Run 1 - 1843
RPM.

Is there any way to force this line break so it shows up on my chart?

Ed



HEK

Line break in X-axis column label?
 
Ed, a line break within a worksheet cell can be forced with <Alt<Enter
(keep the Alt-button pressed while hitting <Enter). I believe this will be
reflected in your chart category label.

GL,
Henk


"Ed" wrote:

I have a chart with the data shown in columns. I am trying to format my
data column in the worksheet so the column label on the X-axis has a line
break that makes sense. I want:
Run 1 -
1843 RPM
but I can't force a break after the hyphen in the worksheet, so I'm getting
Run 1 - 1843
RPM.

Is there any way to force this line break so it shows up on my chart?

Ed




Ed

Line break in X-axis column label?
 
Thank you. It works great!
Ed

"HEK" wrote in message
...
Ed, a line break within a worksheet cell can be forced with <Alt<Enter
(keep the Alt-button pressed while hitting <Enter). I believe this will
be
reflected in your chart category label.

GL,
Henk


"Ed" wrote:

I have a chart with the data shown in columns. I am trying to format my
data column in the worksheet so the column label on the X-axis has a line
break that makes sense. I want:
Run 1 -
1843 RPM
but I can't force a break after the hyphen in the worksheet, so I'm
getting
Run 1 - 1843
RPM.

Is there any way to force this line break so it shows up on my chart?

Ed







All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com