| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to align the category axis to plot area
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!! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to align the category axis to plot area
Format the axis and specify where you want it to cross the y-axis.
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "awrex" wrote in message ... 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!! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to align the category axis to plot area
Hi,
Explanation can be found here, http://www.andypope.info/tips/tip002.htm Cheers Andy awrex wrote: 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!! |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to align the category axis to plot area
Works great!!
Would you happen to know how I could reflect this through VBA. Thanks again!! "Andy Pope" wrote: Hi, Explanation can be found here, http://www.andypope.info/tips/tip002.htm Cheers Andy awrex wrote: 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!! |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to align the category axis to plot area
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 awrex wrote: Works great!! Would you happen to know how I could reflect this through VBA. Thanks again!! "Andy Pope" wrote: Hi, Explanation can be found here, http://www.andypope.info/tips/tip002.htm Cheers Andy awrex wrote: 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!! |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to align the category axis to plot area
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 "Andy Pope" wrote: 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 awrex wrote: Works great!! Would you happen to know how I could reflect this through VBA. Thanks again!! "Andy Pope" wrote: Hi, Explanation can be found here, http://www.andypope.info/tips/tip002.htm Cheers Andy awrex wrote: 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!! |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to align the category axis to plot area
The best thing would be for YOU to record the code. Then you can
incorporate that into the routine. Cheers Andy awrex wrote: 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 "Andy Pope" wrote: 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 awrex wrote: Works great!! Would you happen to know how I could reflect this through VBA. Thanks again!! "Andy Pope" wrote: Hi, Explanation can be found here, http://www.andypope.info/tips/tip002.htm Cheers Andy awrex wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If I do not plot empty cells, how do I change the category axis? | Charts and Charting in Excel | |||
| How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
| excel should make it easier to have a 1 to 1 plot area in chart | Charts and Charting in Excel | |||
| Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
| How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel | |||
Hybrid Mode
