I'm sure this is either easy or impossible. My level of skill is good with Excel, very low with VBA. I'd like to create a chart, and use a variable or name to flexibly set the minimum and maximum values for the X and/or Y axis. When I try, I get an error message that says "Your entry can not be used, an integer or decimal number may be required."
The application is a bowling league. Team members may have scores between zero and three hundred. In order to maximize the use of space, I'd like to set the minimum value of the axis to 10 pins less than the lowest score (season to date), and the maximum value to 10 pins greater than the highest score to date. Finding these scores is, of course easy. Getting the axis to set the min and max values is the part I can't seem to make happen.
I haven't tried using VBA to do this, cause I'm pretty much VBA clueless. Is there, in fact, any way to do this in straight excel? If not, can anyone point me to a VBA example I can crib from? My google-fu failed me. Thanks in advance!!!
The application is a bowling league. Team members may have scores between zero and three hundred. In order to maximize the use of space, I'd like to set the minimum value of the axis to 10 pins less than the lowest score (season to date), and the maximum value to 10 pins greater than the highest score to date. Finding these scores is, of course easy. Getting the axis to set the min and max values is the part I can't seem to make happen.
I haven't tried using VBA to do this, cause I'm pretty much VBA clueless. Is there, in fact, any way to do this in straight excel? If not, can anyone point me to a VBA example I can crib from? My google-fu failed me. Thanks in advance!!!
