Pareto/Bar charts
 

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

Pareto/Bar charts
 

For a working Excel model that will plot your data,
see the Pareto Plotter at this website:
http://www.contextures.com/excelfiles.html#Charts

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Adam" wrote in message
...
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

Pareto/Bar charts
 

Thanks Ron, a few changes and this will work,
Adam

"Ron Coderre" wrote:

For a working Excel model that will plot your data,
see the Pareto Plotter at this website:
http://www.contextures.com/excelfiles.html#Charts

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Adam" wrote in message
...
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

Pareto/Bar charts
 

Glad to help.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Adam" wrote in message
...
Thanks Ron, a few changes and this will work,
Adam

"Ron Coderre" wrote:

For a working Excel model that will plot your data,
see the Pareto Plotter at this website:
http://www.contextures.com/excelfiles.html#Charts

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Adam" wrote in message
...
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