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

C

Conrad

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
 
T

Tushar Mehta

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
 

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

Histogram And Bin Size ? 2
Histogram Question 3
histogram dynamic bin count 0
Histogram bins being ignored 0
Histogram bins driving me crazy-please HELP 5
Help with normal distribution, generating ratios for bell-shape cu 5
Charting cumulative values in histogram ? 3
Auto populate value from one task to another in MS PROJECT 0

Top