If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
axis label multi line help
hello
how do you create multi line axis labeling. I have a bar graph with text angled at 45 degrees under each bar. I would like to set the text so that it is displayed on 2 lines. I tried entering a carraige return (ALT ENTER) in the reference cell but it didnt work. sincerely, sp |
#2
|
|||
|
|||
axis label multi line help
Hi SP
have a look at http://peltiertech.com/Excel/Charts/Staggered.html HTH Frank SP wrote: hello how do you create multi line axis labeling. I have a bar graph with text angled at 45 degrees under each bar. I would like to set the text so that it is displayed on 2 lines. I tried entering a carraige return (ALT ENTER) in the reference cell but it didnt work. sincerely, sp |
#3
|
|||
|
|||
axis label multi line help
Use 2 columns for the labels, with the bottom line of the label in the
left column, and the upper line in the right column. Put no headers on these two columns. Put a header on all the columns that have Y data: Series 1 Series 2 Cat A Line 2 Cat A Line 1 1 2 Cat B Line 2 Cat B Line 1 2 1 Select the entire range, including headers and blank cells, and make your chart, with series in columns. The labels will look like this below the chart: --------------------------------------------------- Cat A Line 1 Cat B Line 1 Cat A Line 2 Cat B Line 2 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ SP wrote: hello how do you create multi line axis labeling. I have a bar graph with text angled at 45 degrees under each bar. I would like to set the text so that it is displayed on 2 lines. I tried entering a carraige return (ALT ENTER) in the reference cell but it didnt work. sincerely, sp |
#4
|
|||
|
|||
axis label multi line help
Wow. Thanks for those replies.
Still some problems Using your example, when i stagger line 1 "Cat A Line 1" the second line remains unstaggered. I cant seem to stagger both. The issue is that the second line "Cat A Line 2" is long and runs into the next second line "Cat B Line 2". and i dont want to break Line 2 into 2 more lines or reduce the font. sincerely, sp Jon Peltier wrote in message ... Use 2 columns for the labels, with the bottom line of the label in the left column, and the upper line in the right column. Put no headers on these two columns. Put a header on all the columns that have Y data: Series 1 Series 2 Cat A Line 2 Cat A Line 1 1 2 Cat B Line 2 Cat B Line 1 2 1 Select the entire range, including headers and blank cells, and make your chart, with series in columns. The labels will look like this below the chart: --------------------------------------------------- Cat A Line 1 Cat B Line 1 Cat A Line 2 Cat B Line 2 |
#5
|
|||
|
|||
axis label multi line help
You can only make each bit as wide as the space between axis labels
assigned by Excel. You can get a bit more room if you hide the regular axis labels, and put a dummy series there, with points along the axis at locations where you want a label, and use data labels on this series linked to the cells instead of axis labels. I recall that the data labels reproduce your hard coded line breaks from the cells somewhat better than the axis labels do. For help, check out the Arbitrary Axis example on my web site: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ SP wrote: Wow. Thanks for those replies. Still some problems Using your example, when i stagger line 1 "Cat A Line 1" the second line remains unstaggered. I cant seem to stagger both. The issue is that the second line "Cat A Line 2" is long and runs into the next second line "Cat B Line 2". and i dont want to break Line 2 into 2 more lines or reduce the font. sincerely, sp Jon Peltier wrote in message ... Use 2 columns for the labels, with the bottom line of the label in the left column, and the upper line in the right column. Put no headers on these two columns. Put a header on all the columns that have Y data: Series 1 Series 2 Cat A Line 2 Cat A Line 1 1 2 Cat B Line 2 Cat B Line 1 2 1 Select the entire range, including headers and blank cells, and make your chart, with series in columns. The labels will look like this below the chart: --------------------------------------------------- Cat A Line 1 Cat B Line 1 Cat A Line 2 Cat B Line 2 |
Thread Tools | |
Display Modes | |
|
|