Hello again,
I am looking for directional help on programming a user form to set the number of values for my X axis on charts. The programs we chart vary for job to job and we use waterfall charts as a means to report. The issue is this, some projects use as little as 3 x values and some programs may use up to 10 bars. The number of X bars and their titles differ each time (no standard template). I want to create a ListBox with a number range from 1 to 12 and then with the selected number from the list box, display TextBoxes to have the user fill in and then the TextBoxes create the X axis values. Has any one done this before? I have seen the Peltier chart add ons, but have not seen if they are flexible with the number of x values...Thanks
Kip
I am looking for directional help on programming a user form to set the number of values for my X axis on charts. The programs we chart vary for job to job and we use waterfall charts as a means to report. The issue is this, some projects use as little as 3 x values and some programs may use up to 10 bars. The number of X bars and their titles differ each time (no standard template). I want to create a ListBox with a number range from 1 to 12 and then with the selected number from the list box, display TextBoxes to have the user fill in and then the TextBoxes create the X axis values. Has any one done this before? I have seen the Peltier chart add ons, but have not seen if they are flexible with the number of x values...Thanks
Kip
