Two X-axis labels in Graphs

ramankumar

New Member
Joined
Sep 8, 2002
Messages
33
I have to show labels on x-axis like this. I can show one level of x-axis labels. But i don't know how to show two levels in x-axis.


T1 T2 T3 T4 T1 T2 T3 T4 T1 T2 T3 T4
Jan Feb Mar


Experts any advice? I could not find anything like this in many message boards?

Best Regards,
Ramana Kumar
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

ThePencilQueen

Board Regular
Joined
Jun 26, 2002
Messages
109
The cells that you use for the X - axis labels just need to contain the entire title (so Jan T1, Jan T2, Jan T3, Feb T1 etc etc).
 

ramankumar

New Member
Joined
Sep 8, 2002
Messages
33
Thank you. I thought about the same. But Our requirements won't allow me to do like that.

I want the labels in the same way i posted in my orginal mail? Is this possible?
 

zzydhf

Board Regular
Joined
Apr 10, 2002
Messages
236

ADVERTISEMENT

I currently do this by right clicking the chart, choose source data. Click the series tab. In the box labeled category (x) axis labels. Select or type in the range - eg. "='for charts'!$G$28:$H$48"

one thin I have noticed is the range has to be concurrent columns- a&b or b&c etc.
 

Deb G.

Board Regular
Joined
Mar 4, 2002
Messages
133
Don't know if this is what you are looking for but you can always put a text box under the axis and manually enter the months that you want. Format the text box to show no line around the box and this should do it.
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Suppose your worksheet looks like this...
Book1
ABCDEFGHIJK
1JanT127
2T214
3T360
4T438
5FebT150
6T289
7T391
8T446
9MarT182
10T223
11T332
12T483
13
14
15
Sheet1


...just select A1:C12 and click on the Chart wizard. This will create a chart with an x-axis as you requested. The chart's SERIES function will look like this...

=SERIES(,Sheet1!$A$1:$B$12,Sheet1!$C$1:$C$12,1)

For more on this matter see the Excel Help topics for...

- "Change the spacing of tick marks and labels on the category axis"

- "Change the alignment and spacing of multiple-level category labels"
 

Forum statistics

Threads
1,144,437
Messages
5,724,356
Members
422,546
Latest member
KevinOnTheDaily

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top