Create chart based on information selected in a form

[deante]

I have a sheet within excel that contains data in columns such as Technology type and different types of products from that technology. The data sheet looks like this:

Technology Process Number Product 1 Product 2 Product 3
Tech 1 1 15 30 45
Tech 2 1 15 45 30
Tech 1 2 45 30 15
Tech 3 1 30 14 30
Tech 3 2 45 12 50
Tech 1 3 16 17 18

I would like a user to be able to select which technologies they want to find information on. Lets say a user wanted information on Tech 1 and Tech 2. Once the user selects Tech 1 and Tech 2 I want a chart with the x axis labled Process number, y axis with total number of products, and a bar chart with the data of the total number of products to automatically generate. In this example it would have Process 1 a total of 254Process 2 a total of 197, and Process 3 a total of 51.

If there is anyone able to help me I will greatly appreciate it.

Thanks in Advance,

DeAnte

 

[SkipVought]

Hi,

FIRST, Normalize your data.
[tt]
Technology Process Number Product ProdVal
Tech 1 1 Product 1 15
Tech 2 1 Product 1 15
Tech 1 2 Product 1 45
Tech 3 1 Product 1 30
Tech 3 2 Product 1 45
Tech 1 3 Product 1 16
Tech 1 1 Product 2 30
Tech 2 1 Product 2 45
Tech 1 2 Product 2 30
Tech 3 1 Product 2 14
Tech 3 2 Product 2 12
Tech 1 3 Product 2 17
Tech 1 1 Product 3 45
Tech 2 1 Product 3 30
Tech 1 2 Product 3 15
Tech 3 1 Product 3 30
Tech 3 2 Product 3 50
Tech 1 3 Product 3 18
[/tt]
Then you can use a PivotTable/PivotChart.

All together, normalizing your example, and generating a PivotTable/PivotChart took about 3 minutes.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]