| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Setting Y axis display labels
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Setting Y axis display labels
Hi,
Your not referencing the actual chart. Amend your code. Also the second with does not require the chtobj. For Each chtobj In aWS.ChartObjects Debug.Print chtobj.Name With chtobj.chart With .Axes If Power <= 2 Then Cheers Andy Barb Reinhardt wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
