How do I get the X axis (category) name to show?

B

BellaLuna

I've created a 3d bar graph. Originally the Z and X axis title appeared, but
the X axis also had three of the 10 categories. I have a legend to identify
each of the 10 items, so all I want is the title of the categories. When I
roll my cursor over the area it pops up "category axis title" but I can't
right click or firmat the area.
Any clues?
 
P

Peter T

Select the X-Axis, if you hover for a while tooltip "Category axis" may
appear. Double click or rt-click the Axis to display its "Format Axis"
dialog

Scale tab: change 'no. of categories between tick mark labels' to 1.
You may then need to adjust Font size and/or Alignment angle to suit, under
Font & Alignment tabs respectively.

Alternatively, double click the series (your columns),
DataLabels tab: Show Label, position to suit

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Position of X axis labels 4
X-Axis Appearing in Plot Area 2
X Axis to Scale 2
How do I extend the X-axis in Excel2007 3
Can I use non-numeric x axis data in excel charts? 2
move y-axis to the left of x-axis "0" 3
Variables on X & Y Axis 2

Top