I have a dataset, numerical values in groups of 13. In this example, there are 3 groups, totalling 39 values.
I have used function CountIf to check if any numbers in a group of 13 values, are greater than 9. So taking the 3 groups, CountIf has given me 2, 2, 3 in row 6.
I have then checked the data using "a moving group of 13", i.e. from C4 to O4, and the count of 2 appears in cell C8, vertically below the initial data number in the group, C4. Then repeating, moving the start of the group of 13, 1 cell at a time.
The scatter graph shows the values of the first group of 13, with 2 numbers higher than 9.
My problem: how do i get VB macro to allow me to change the x-values on the chart, by clicking on the starting number, e.g. F4, or UpDown control (or similar)?
In the original dataset, there are hundreds of numbers so creating a button under each number would be impractical. Row 3 actually contains dates (when the testing was done), so a drop down box might work.
Any thoughts please!
Bill
Bookmarks