Format Chart's Y-axis . Urgent

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Any help will be appreciated and thax in advance

Gin Lye.
 
Hi Gin
try something like:

With ActiveChart.Axes(xlValue)
.MinimumScale = 0
.MaximumScale = 1
End With

Frank
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Previous Excel Question 1
Function Based on Chart Data Won't Recalculate 1
Chart Question 1
create chart with column axis 10
Macro to graph (or draw) a vertical line on the chart 7
VB Chart 1
Charts with Time as X-Axis 6
VBA code for Chart with x and y axis 2

Back
Top