ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I get the X axis (category) name to show? (https://www.excelbanter.com/charts-charting-excel/180708-how-do-i-get-x-axis-category-name-show.html)

BellaLuna

How do I get the X axis (category) name to show?
 
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?

Peter T

How do I get the X axis (category) name to show?
 
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

"BellaLuna" wrote in message
...
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?





All times are GMT +1. The time now is 04:52 PM.

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