Use VBA to set minimum/maximum for y-axis

[silenzoe]

Hi everyone,

I have been searching online to find out how to use VBA to set minimum/maximum for the y-axis for a bar graph that I have created.

The bar graph changes based on the list selection that I set above the graph. I have two sets of data, one range from 0-100 whereas the other set ranges from 60-100.

Is there a code that I can write so that when you choose the selection #2, the axis would start at 60?

Thanks,
Zoe

 

[Somendra Misra]

Hi,

See the file.

Regards,