How to align the category axis to plot area

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

awrex - 02 Nov 2006 19:48 GMT

I'm trying to align my category axis of my chart to the bottom of my plot
area. I have some negative data and it's moving the date (category axis) into
the data of the plot area.

Hope this make sense. Thanks!!

Reply to this Message

Bernard Liengme - 02 Nov 2006 20:10 GMT

Format the axis and specify where you want it to cross the y-axis.

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> I'm trying to align my category axis of my chart to the bottom of my plot
> area. I have some negative data and it's moving the date (category axis)
> into
> the data of the plot area.
>
> Hope this make sense. Thanks!!

Reply to this Message

Andy Pope - 02 Nov 2006 20:47 GMT

Hi,

Explanation can be found here,
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

> I'm trying to align my category axis of my chart to the bottom of my plot
> area. I have some negative data and it's moving the date (category axis) into
> the data of the plot area.
>
> Hope this make sense. Thanks!!

Reply to this Message

awrex - 02 Nov 2006 23:04 GMT

Works great!!

Would you happen to know how I could reflect this through VBA.

Thanks again!!

> Hi,
>
[quoted text clipped - 9 lines]
> >
> > Hope this make sense. Thanks!!

Reply to this Message

Andy Pope - 03 Nov 2006 09:55 GMT

The simplest thing to do is use the macro recorder whilst you apply the
settings.

ActiveChart.Axes(xlCategory).Select
.MajorTickMark = xlOutside
.MinorTickMark = xlNone
.TickLabelPosition = xlLow ' < this line does it
End With

Cheers
Andy

> Works great!!
>
[quoted text clipped - 15 lines]
>>>
>>>Hope this make sense. Thanks!!

Reply to this Message

awrex - 04 Nov 2006 01:06 GMT

Thanks Andy....

However I get a runtime error 438... Object doesn't support this property or
method.

I have some existing code that I was attempting to insert this into to clean
up the data results..... here's the snippet....
FYI.. the added portion was added after I ran it sans addition with same 438
error...

Selection.Position = xlBottom
ActiveChart.Axes(xlCategory).Select
Selection.TickLabels.NumberFormat = "mm/dd"
With Selection.TickLabels
.Alignment = xlCenter
.Offset = 100
.ReadingOrder = xlContext
.Orientation = xlUpward
End With
ActiveChart.Axes(xlCategory).Select 'just added 11-3-06
With Selection.TickLabels <---- I added this from your code posted earlier
.MajorTickMark = xlOutside
.MinorTickMark = xlNone
.TickLabelPosition = xlLow ' < this line does it
End With
ActiveChart.ChartTitle.Select
Selection.AutoScaleFont = True

> The simplest thing to do is use the macro recorder whilst you apply the
> settings.
[quoted text clipped - 27 lines]
> >>>
> >>>Hope this make sense. Thanks!!

Reply to this Message

Andy Pope - 04 Nov 2006 13:52 GMT

The best thing would be for YOU to record the code. Then you can
incorporate that into the routine.

Cheers
Andy

> Thanks Andy....
>
[quoted text clipped - 55 lines]
>>>>>
>>>>>Hope this make sense. Thanks!!

Reply to this Message