Can I change BIN values for a histogram from 0.05 incr to .01?

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

Guest

Hi, can anyone please help me out. I have completed a lot of histograms but
know have to change the bin value increments from 0.05 to 0.01 is this
possible or do I have to redo them all.

THANKS
Conrad
 
I cannot think of any way to have XL change the bin values
automatically. You will have to either make the changes by hand or
with some kind of a macro. Of course, you will have to weigh the cost
of writing and debugging the macro against the potential saving after
it works as expected.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top