ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can I change BIN values for a histogram from 0.05 incr to .01? (https://www.excelbanter.com/charts-charting-excel/36358-can-i-change-bin-values-histogram-0-05-incr-01-a.html)

Conrad

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

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

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



All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com