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

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.



"afdmello" wrote:

> 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
>
>
> .
>

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/5/2010 5:39 AM, afdmello wrote:
> 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
>
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
> -------
> Jon Peltier
> Peltier Technical Services, Inc.
> http://peltiertech.com/
>
>
> On 3/5/2010 5:39 AM, afdmello wrote:
>> 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
>>
>>

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/5/2010 10:46 AM, afdmello wrote:
> 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"<(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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
>> -------
>> Jon Peltier
>> Peltier Technical Services, Inc.
>> http://peltiertech.com/
>>
>>
>> On 3/5/2010 5:39 AM, afdmello wrote:
>>> 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
>>>
>>>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Sounds like you have a blank series, which without overlap pushes the
> other series to the side so there is room for both.
>
> - Jon
> -------
> Jon Peltier
> Peltier Technical Services, Inc.
> http://peltiertech.com/
>
>
> On 3/5/2010 10:46 AM, afdmello wrote:
>> 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"<(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> 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
>>> -------
>>> Jon Peltier
>>> Peltier Technical Services, Inc.
>>> http://peltiertech.com/
>>>
>>>
>>> On 3/5/2010 5:39 AM, afdmello wrote:
>>>> 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
>>>>
>>>>
>>
>>

> =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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/5/2010 2:41 PM, afdmello wrote:
> 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"<(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Sounds like you have a blank series, which without overlap pushes the
>> other series to the side so there is room for both.
>>
>> - Jon
>> -------
>> Jon Peltier
>> Peltier Technical Services, Inc.
>> http://peltiertech.com/
>>
>>
>> On 3/5/2010 10:46 AM, afdmello wrote:
>>> 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"<(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> 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
>>>> -------
>>>> Jon Peltier
>>>> Peltier Technical Services, Inc.
>>>> http://peltiertech.com/
>>>>
>>>>
>>>> On 3/5/2010 5:39 AM, afdmello wrote:
>>>>> 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
>>>>>
>>>>>
>>>
>>>
>
>