View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Y-labeling issue

Try selecting the axis labels by clicking on one of them to select them and
then right clicking on it and select format axis.

In xl2002 select Scale tab and set Number of categories between tick mark
lables to 1. (I think it is the same or similar for xl2003)

In xl2007 under Axis options Specify interval unit 1.

Regards,

OssieMac

"quattda" wrote:

When I create a bar chart having weekdays/dates along the Y-axis. only every
other labels is displayed (i.e., Mon, Wed, Fri). I changed the Axis to
Category, rotated the text, changed the format to m/d, chose the days both
individually and as a range. Nothing seems to work. Any suggestions about how
to get this to work?