Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5,600
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I plot value on x axis and category on y axis? Ben K. Charts and Charting in Excel 1 August 3rd 07 06:38 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
Axis category Svilen Pachedzhiev Charts and Charting in Excel 2 November 7th 05 08:33 AM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"