Hi,
I have month wise data to compute in and out of particular product. I have written macros to calculate. In and out values are in different sheets.
Now i want to create a dynamic column chart to plot it automatically. not sure how to povide the range as month values vary depend on input
Please let me know how to do this
Data:
In
Jan FEb Mar
10 20 30
Out:
Jan FEb Mar
5 10 15
I have month wise data to compute in and out of particular product. I have written macros to calculate. In and out values are in different sheets.
Now i want to create a dynamic column chart to plot it automatically. not sure how to povide the range as month values vary depend on input
Please let me know how to do this
Data:
In
Jan FEb Mar
10 20 30
Out:
Jan FEb Mar
5 10 15