| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I change BIN values for a histogram from 0.05 incr to .01?
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 |
|
#2
|
|||
|
|||
|
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 In article , says... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
| Change all values in an excel column at once? | Excel Discussion (Misc queries) | |||
| Charting cumulative values in histogram ? | Charts and Charting in Excel | |||
| How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
Linear Mode
