Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I plot value on x axis and category on y axis? | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Axis category | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel |