Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Setting reverse order for axis in OWC 11 chart component
I must say , working with the component is pretty much a nightmare and
waste of time, as the structure is convoluted, different than Excel, and there's no macro recorder to aid in figuring out the bizarre calls. That off my chest I can't seem to nail down or find anywhere, the command to reverse the axis plotting, which is available from the wysiwyg under the Axis editor, as order - Show values in reverse order. The excel version reverseplotorder , is not available. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Setting reverse order for axis in OWC 11 chart component
Hi,
I hate to show my ignorance but what is OWC 11? -- If this helps, please click the Yes button Cheers, Shane Devenshire "JoeG" wrote: I must say , working with the component is pretty much a nightmare and waste of time, as the structure is convoluted, different than Excel, and there's no macro recorder to aid in figuring out the bizarre calls. That off my chest I can't seem to nail down or find anywhere, the command to reverse the axis plotting, which is available from the wysiwyg under the Axis editor, as order - Show values in reverse order. The excel version reverseplotorder , is not available. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Setting reverse order for axis in OWC 11 chart component
Here is the code generated when I record in Excel 2003
ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.Axes(xlCategory).Select With ActiveChart.Axes(xlCategory) .TickLabelSpacing = 1 .TickMarkSpacing = 1 .ReversePlotOrder = True .AxisBetweenCategories = False End With maybe this will help -- If this helps, please click the Yes button Cheers, Shane Devenshire "JoeG" wrote: I must say , working with the component is pretty much a nightmare and waste of time, as the structure is convoluted, different than Excel, and there's no macro recorder to aid in figuring out the bizarre calls. That off my chest I can't seem to nail down or find anywhere, the command to reverse the axis plotting, which is available from the wysiwyg under the Axis editor, as order - Show values in reverse order. The excel version reverseplotorder , is not available. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Setting reverse order for axis in OWC 11 chart component
OWC is Office Web Components, not the main Excel program. It uses in many
cases different syntax for the same thing, the the generated code would not work for me. Thanks for the try. "Shane Devenshire" wrote: Here is the code generated when I record in Excel 2003 ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.Axes(xlCategory).Select With ActiveChart.Axes(xlCategory) .TickLabelSpacing = 1 .TickMarkSpacing = 1 .ReversePlotOrder = True .AxisBetweenCategories = False End With maybe this will help -- If this helps, please click the Yes button Cheers, Shane Devenshire "JoeG" wrote: I must say , working with the component is pretty much a nightmare and waste of time, as the structure is convoluted, different than Excel, and there's no macro recorder to aid in figuring out the bizarre calls. That off my chest I can't seem to nail down or find anywhere, the command to reverse the axis plotting, which is available from the wysiwyg under the Axis editor, as order - Show values in reverse order. The excel version reverseplotorder , is not available. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Setting reverse order for axis in OWC 11 chart component
Sorry to arrive a bit late on the scene, but the following should do
the trick (the default is MinMax): cht.Axes[0].Scaling.Orientation = ChartScaleOrientationEnum.chScaleOrientationMaxMin ; OWC is not very developer-friendly - the Microsoft Chart Controls for .NET Framework are a much better option: http://code.msdn.microsoft.com/mschart Best wishes John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart X-Axis in reverse order! | Excel Discussion (Misc queries) | |||
Reverse chart column and row order | Charts and Charting in Excel | |||
Reverse chart order | Charts and Charting in Excel | |||
Reverse chart order | Charts and Charting in Excel | |||
How to reverse the order of bars in Bar Clustered chart? | Excel Discussion (Misc queries) |