![excel histogram set lower range excel histogram set lower range](https://i1.wp.com/www.bluepecantraining.com/wp-content/uploads/2015/12/Histogram-Chart.png)
Here is the top part of a worksheet with the numbers 0 through 235 in column A and the probability of that many sixes being thrown in 235 tosses of a fair die in column B. Max_X_Axis = Application.InputBox(Prompt:="Enter Maximum Date (MM/DD/YYYY), Number, or Select Cell", Type:=1)ĪctiveChart.Axes(xlCategory).MaximumScale = Max_X_Axis MsgBox ("You must be in a chart."),, "Oops!"
![excel histogram set lower range excel histogram set lower range](https://i.ytimg.com/vi/Pgid2H7JVNM/maxresdefault.jpg)
Min_X_Axis = Application.InputBox(Prompt:="Enter Minimum Date (MM/DD/YYYY), Minimum Number, or Select Cell", Type:=1)ĪctiveChart.Axes(xlCategory).MinimumScale = Min_X_Axis (Do not enter a date for the kind of scaling you're trying to do here.) This is the only way I know of to rescale the "unscalable" axis. If you want to plot columns 5 through 36, set 5 as the x-axis minimum, and 36 as the x-axis maximum. just because the first column is labeled some number, it is still 1 on the axis scale. This kind of x-axis is based on a count, i.e. You can run the following macros to set the limits on the x-axis.