Previous Excel Question

[Guest]

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

Thanx for all responses

Gin Lye.

 

[Tom Ogilvy]

Turn on the macro recorder and perform the action. This should give you
the basic code you need.

--
Regards,
Tom Ogilvy

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.