drop down boxes

Yes I know this is NOT really a charting problem but this is where the forum insisted i put it.

I tried combo boxes - but they did not seem to help.

i want to have an input box where i can select say 5 cities and have a chart of the weather in all those cities.

thanks

Originally Posted by Richard Buttrey

Hi,

No reason why combo boxes wouldn't allow you to select the cities, but you're still going to have to tell the system what to do with them.

Another approach would be to create 5 input cells, say A5:A9 and put a data validation in those cells using the List option, and specify the list of cities as the list range.

Now put the label 'City' above the first city in the list and name the whole table say 'Cities'.

Put the same label 'City' in A4, so that A4:A9 becomes a criteria filter

Now copy the first row of your table to another area which will become the output area for a Data Filter

You can now use Data Filter Advanced to extract cities from your database to the new area using A4:A9 as the criteria.

Finally link your chart to this output area.

Incidentally you appear to have duplicate city names in the table. You'll probably want to tidy that up first.

HTH

Thanks very much.
I don't understand it yet- but i will do my best!
yes the data is imperfect- it comes from noaa

Try this...

Originally Posted by Chance2

Try this...

somehow thanks doesn't seem enough so
a million thanks

i am very puzzled about your solution.
i am trying to duplicate it in the spread sheet, via several sheets, so i can include, low temps, rain stats. etc
and your boxes stay visible!
haven't figured it out yet!

The drop down boxes remain visible because they are "form" drop downs (not lists like the previous solution). The list solution will work as well, I just thought you wanted drop downs!

As for the data on the charts, that is mainly named ranges. You could use some kind of INDIRECT to refer to the different sheets as long as all the sheets had the same number of rows/columns. It's a little trickier, but doable.

this problem is now solved - thanks all