I need an MVP...!

R

Ray

Hello -

I need to create a 'dynamic' chart, with plotted data being 'chosen' by
the user. Let's use this example:
Say my company sells 9 models of shoes: Model1, Model2....Model9.
There are 3 categories of shoes: Sports, Mens, Womens. Further, we
have many stores selling the shoes and they can be grouped several
ways: Total (ie North America); by Country (us or ca), by Region (ie
US-East), or simply by Store (ie #210). There is only piece of
information available for each shoe: number of pairs in stock, but this
data is available on a weekly level.

Managers want to be able to see how stock levels have developed over
time, but need to be able to see such development on multiple levels
(ie by store, by model, by country, etc). My thought was to create
drop-down boxes for each of the 'levels' of data, with users selecting
the view they wanted and the graph updating automatically. The source
data is a raw (ie not pivoted) worksheet, with each row containing ALL
of the data pieces above (Country, Region,Store#, model, etc).

But how do I use the drop-down box selections to modify the source
data, and thus the graph? The series-name should also change to
reflect the chosen options. OR, maybe you can suggest another way to
do what I need...?

Any/all help is GREATLY appreciated!

Rgds, Ray
 
R

Ray

Excellent! I've never used a PivotChart before, but a quick
run-through looks promising. I've also bookmarked your link below --
some great solutions!

Thanks alot, Ed....

Rgds, Ray
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top