Maikel
10-07-2010, 03:12 AM
Hey all,
I've been wondering. Is it possible to create a graph with the help of VBA to have it automatically add same categories and add values without having to make a new data-table in excel and use that as sourcedata instead?
sample:
24-2010 3
25-2010 5
24-2010 4
26-2010 6
24-2010 4
25-2010 2
to be treated if the sourcedata has been:
24-2010 11
25-2010 7
26-2010 6
so what im actually looking for is for a way to create a stacked column graph which shows all values of categories, but enables u to see the seperate records as well. This can be achieved by having some way to let excel not use multiple occurences of the same values on the X-axis.
Any help would be greatly appreciated.
The way of making a new datatable when trying to do this is what i used to do in the past but i'm almost certain it can be done without even with VBA.
I've been wondering. Is it possible to create a graph with the help of VBA to have it automatically add same categories and add values without having to make a new data-table in excel and use that as sourcedata instead?
sample:
24-2010 3
25-2010 5
24-2010 4
26-2010 6
24-2010 4
25-2010 2
to be treated if the sourcedata has been:
24-2010 11
25-2010 7
26-2010 6
so what im actually looking for is for a way to create a stacked column graph which shows all values of categories, but enables u to see the seperate records as well. This can be achieved by having some way to let excel not use multiple occurences of the same values on the X-axis.
Any help would be greatly appreciated.
The way of making a new datatable when trying to do this is what i used to do in the past but i'm almost certain it can be done without even with VBA.