bar chart

[afdmello]

I have made a bar chart but the axis descriptors are not aligned with the
bar. What I mean to say is they are not in the middle of the tick marks
How can i align them?

afd

 

[trip_to_tokyo]

EXCEL 2007

I have just checked one of my bar charts where they are lined up properly.

Try the following:-

- click in the Vertical Axis to highlight it

- right click and select Format Axis (window of same name should pop up)

- Axis Options should be highlighted on left hand side. In here make sure
that:-

1. Interval between tick marks: is set to 1

2. Interval between labels: try setting to Automatic

3. Axis Type: set this to Automatically select based on data

4. Major tick mark type: set to Outside

5. Minor tick mark type: set to None

6. Axis labels: set to Next to Axis

If the above does not work try playing with the above settings until you get
what you want.

If my comments have helped please hit Yes.

Thanks.

 

[Jon Peltier]

Is it a date-scale axis? For example, if you have weekly data, often you
get a tick for the beginning of the week, but the data is elsewhere in
the week.

Are the labels oriented other than horizontal or vertical? Inclined
labels seem to align with the planets, not with the chart.

- Jon

 

[afdmello]

Thank you Jon and trip to Tokyo, I checked out again and observed that the
labels are in the center between the tick marks

The labels are not week days but they are text. The truth is the bars are
not in the center of the tick marks.
I clicked in the chart area> format data series> Series overlap( was 2%) I
made it 100% ( the bar became bigger in width). Next I clicked on Gap
width( was105%) made it 200% and now it is OK
Just posted to ensure my workaround was accepted by the gurus
Thank you for your time and suggestions

afd

 

[Jon Peltier]

Sounds like you have a blank series, which without overlap pushes the
other series to the side so there is room for both.

- Jon

 

[afdmello]

Jon,

How can I determine there is a blank series?

I have 7 rows of data and 2 columns of data and that is plotted

=SERIES(,Trainings!$BG$5:$BG$11,Trainings!$BO$5:$BO$11,4)

afd

 

[Jon Peltier]

=SERIES(,Trainings!$BG$5:$BG$11,Trainings!$BO$5:$BO$11,4)

The "4" inside the last paren indicates this formula is for the 4th
series. Select a series and use the arrow keys to cycle through the
other series (and other chart elements). See any gaps in the series
numbering? Do the selection indicators ever drop to the bottom for a series?

- Jon