A
Adam
Having trouble trying to create functions to do the following:
create a pareto of following data on a weekly and monthly, quartely etc basis:
Code Value
a 5
b 10
c 0
d 1
e 1
f 5
g 3
a, b, c etc could be different values every week month etc
How can I create the graphs in advance so that when the data is copied to
the data tab sheet it is automatically sorted high to low(possibly in another
table where the graph pulls the info.)
also need to ignore zero values (may have 32 items and 12 of them are zero,
no need to graph)
.....sort and plot those data sources that are non-zeros, format chart area
to auto fit the number of series plotted.
I tried ranking the values first then doing a vlookup to sort them in
another table and then the graph could pull from there, only problem is it
skips duplicate 'values'...that is, takes the first one and skips the rest of
the same values.
If all of this is too confusing, send me an email/address and I can send a
worksheet of what I am trying to finish
thx
adam
create a pareto of following data on a weekly and monthly, quartely etc basis:
Code Value
a 5
b 10
c 0
d 1
e 1
f 5
g 3
a, b, c etc could be different values every week month etc
How can I create the graphs in advance so that when the data is copied to
the data tab sheet it is automatically sorted high to low(possibly in another
table where the graph pulls the info.)
also need to ignore zero values (may have 32 items and 12 of them are zero,
no need to graph)
.....sort and plot those data sources that are non-zeros, format chart area
to auto fit the number of series plotted.
I tried ranking the values first then doing a vlookup to sort them in
another table and then the graph could pull from there, only problem is it
skips duplicate 'values'...that is, takes the first one and skips the rest of
the same values.
If all of this is too confusing, send me an email/address and I can send a
worksheet of what I am trying to finish
thx
adam