Create chart based on user criteria

[ktb916]

Hi!

I'm trying to create a chart based on 1 - a selection of data contained on a sheet and 2 - criteria a user can enter about the data - like a specific category and date range.

so the user chooses a category from a drop down list - enters a data range (1/2004 to 12/31/2004) - then clicks a button and using this criteria the program creates a chart and displays it on the sheet.

I haven't really looked at VBA charting functionality yet but i thought i would ask first and maybe save myself a step or 2.

Any help always appreciated.

KT

 

[Geneticus]

Is the dropdown in the sheet, a Userform, or in Data Validation?

Will the Chart be placed as an object in the same sheet or as a new Sheet?

 

[ktb916]

The dropdown will be in the sheet and i want to show the chart on the same sheet. Also there are 2 more drop downs that let the user select a date range.

KT