Previous Excel Question
 

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.

Previous Excel Question
 

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

--
Regards,
Tom Ogilvy


"Gin Lye" wrote in message
...
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.