Hello everyone,

my problem is the following: I can not seem to workout how one adds X-Axis labels to a chart in VBA based upon a range which depends on a variable within the code.


The file is a Binomial Distribution automated by a macro. Since the X in the left column starts at 0 and the legend in the chart starts at 1, the X is not correctly attributed to the columns in the chart.
How is it possible to adjust the X Axis legend to a range, which depends upon the number of n in cell "C2"?
Code for the chart:
Please Login or Register  to view this content.
Thank you so much for your help in advance,