Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
What am I doing wrong he
For Each chtobj In aWS.ChartObjects Debug.Print chtobj.Name With chtobj With chtobj.Axes If Power <= 2 Then .displayunits = "Hundreds" ElseIf Power <= 3 Then .displayunits = "Thousands" ElseIf Power <= 6 Then .displayunits = "Millions" ElseIf Power <= 9 Then .displayunits = "Billions" ElseIf Power <= 12 Then .displayunits = "Trillions" End If End With End With Next chtobj I'm just guessing on .displayunits because I haven't been able to find any reference for it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change tick mark labels in z axis from values to texts? | Charts and Charting in Excel | |||
Scatter chart with text labels as Y axis? | Charts and Charting in Excel | |||
LONG CATEGORY AXIS LABELS ARE BROKEN INTO 2 LINES | Charts and Charting in Excel | |||
How do I display columns side-by-side in a two Y axis chart? | Charts and Charting in Excel | |||
Linking Axis Labels | Charts and Charting in Excel |