Prev: How to do a pivot table with 2 different results
Next: Secondary Axis - Alignment of Dollar Values
From: afdmello on 5 Mar 2010 05:39
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


From: trip_to_tokyo on 5 Mar 2010 07:21
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
>
>
> .
>
From: Jon Peltier on 5 Mar 2010 08:02
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
>
>
From: afdmello on 5 Mar 2010 10:46
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" <jonNO(a)SPAMpeltiertech.com> wrote in message
news:%23FtLlQGvKHA.796(a)TK2MSFTNGP05.phx.gbl...
> 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
>>
>>


From: Jon Peltier on 5 Mar 2010 14:28
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"<jonNO(a)SPAMpeltiertech.com> wrote in message
> news:%23FtLlQGvKHA.796(a)TK2MSFTNGP05.phx.gbl...
>> 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
>>>
>>>
>
>
 |  Next  |  Last
Pages: 1 2
Prev: How to do a pivot table with 2 different results
Next: Secondary Axis - Alignment of Dollar Values