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
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