On the Formulas tab of the Ribbon, click Define Name, enter the name 'counts', give it a scope of the active worksheet (I kept the default name Sheet1), and enter this formula:

We'll define a couple of dynamic range names (what Excel calls 'Names'). The Min and Max of the first column are given in E1 and E2, along with the initial chart of the data. 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!' 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.

Change axis type on excel for mac