listbox and charting

S

stevem

Got a little problem I need some help with..

I've got 1 worksheet that tracks arcade games and token counts..

Column A is Name of Machine.. Columns B-Whatever are the token count
from every 2 weeks.

I'd like to create a second sheet that has a pulldown list that
generated from column A of the first sheet. Then when an item i
selected, it creates a line chart based on the row matching the nam
that was selected from the list. I'd also like a chart that now onl
charts the actual numbers, but shows the rolling average overlaid o
the chart (if possible).

Also if possible, I'd like to be able to select multiple items from th
pulldown list, and chart each game seperately, plus the combined rollin
average.

Any ideas how to accomplish this, because right now I'm brain dead
 
A

Alex

Hello

Good news and bad.

What you want to do is feasible...but not easily accomplished and requires
VBA code.

I have a single chart I constructed that has a drop down menu with 80
different variables. Upon selection I get the chart aswell as being able to
select from 10 different time frames.

So, you could have a single worksheet where you can input the name of the
game and the token count. Then you could have a single chart with a list box
attached. So if you select 'Game1' then the data for game 1 appears. The same
for Game2 etc. Also, you could have a button attached that will display an
average of that data - sort of like a moving average.

Being truthful, it would be all but impractical to show how to do it via
email. You may be better advised to get somebody to build it. It wouldn't
take half a day.

Regards


Alex

Know any
 
Top