how to center x-axis data label on column graph?

susisu · #1 08-14-2008, 12:21 PM

I can't figure out for the life of me how to center the x-axis labels between the tick marks (there are several different columns per period on the x-axis as well as two different labels for each period (x axis= time and #, y=amounts in, out and total).

Also, for some reason, either the first or last period has an extra tick mark and squishes the labels into the first section- how do I get rid of the extra tick mark?

Rubeus_Hagrid · #2 08-14-2008, 12:29 PM

Hi,

Right click on the data lables --> format data lables. Select the Alignment tab and select center in lable position.

susisu · #3 08-14-2008, 12:37 PM

Thank you, but that doesn't work. I didn't mention that one set is centered (except for the last period where there's that extra tick mark), but then the other one stays on the left section.

Also, is there any way to format the labels so that it's more compact in terms of paragraph spacing? I tried the different options under format axis such as "Label distance from axis," but the labels take up still take up an inch of space unless I chop off one of the labels.

**Andy Pope** · #4 08-15-2008, 06:34 AM

You do not have much if any control over individual axis labels.

Posting an example workbook may help illustrate your problem to those trying to help.
Also tell us which version of Excel you are using.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)