Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Chart's Y-axis . Urgent
Does anyone know to format the Y-axis value during vb run-time
I use vb6 to generate the Chart on Excel sheet and now i wan to format the Y-axis value This is because my Y-axis value is in Percentage value and the autoscalling value will more than 100% value Any help will be appreciated and thax in advance Gin Lye. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Chart's Y-axis . Urgent
Hi Gin
try something like: With ActiveChart.Axes(xlValue) .MinimumScale = 0 .MaximumScale = 1 End With Frank Gin Lye wrote: Does anyone know to format the Y-axis value during vb run-time. I use vb6 to generate the Chart on Excel sheet and now i wan to format the Y-axis value. This is because my Y-axis value is in Percentage value and the autoscalling value will more than 100% value. Any help will be appreciated and thax in advance. Gin Lye. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Chart's Y-axis . Urgent
Hi Frank
i tried this before the problem is, it can only run one-time After that, error occur How to deal it Gin Lye. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting or moving a radar chart's axis labels | Excel Discussion (Misc queries) | |||
Delete chart's custom number format? | Charts and Charting in Excel | |||
How to let pivot table chart's format stay after refreshing data. | Charts and Charting in Excel | |||
How do I change a Chart's axis scale from visual basic? | Charts and Charting in Excel | |||
Urgent Help Needed: X axis to scale | Charts and Charting in Excel |