Hello, i have a question about graphs in VBA.
In my worksheet, Column A has the dates and columns B to F have different series of dates. I have created a formula that locates a data range. For example, the user needs to see the data from 1 jan to 1 feb only, so the formula finds this info from another worksheet. Then, I can create graphs using VBA for the whole data range. However, I would like to include a button that the user selects the only data he wants to see in the graph and the graph will only show this.
what code can I use for this??
Thank you!
In my worksheet, Column A has the dates and columns B to F have different series of dates. I have created a formula that locates a data range. For example, the user needs to see the data from 1 jan to 1 feb only, so the formula finds this info from another worksheet. Then, I can create graphs using VBA for the whole data range. However, I would like to include a button that the user selects the only data he wants to see in the graph and the graph will only show this.
what code can I use for this??
Thank you!
