| 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 | |||
Hybrid Mode
