# How to define multiple groups with data in the same column

1. ## How to define multiple groups with data in the same column

Starting with a spreadsheet full of data. In Column "A" contains the "production line" , column "B" contains the "production date", Column "C" contains the "Product" and column "D" contains the response data.

Is it possible to use "defined names" to create multiple groups which could be graphed? (Defined Range?)
If not, is there another way to do the same thing? It is possible to use countifs to set the same criteria...

Group 1 - Column A = "Line 1", Column B > "January 1, 2012", Column C = "Widget1"
Group 2 - Column A = "Line 3", Column B > "January 1, 2012", Column C = "Widget1"
Group 3 - Column A = "Line 1", Column B > "January 1, 2012", Column C = "Widget2"
Group 4 - Column A = "Line 4", Column B > "January 1, 2012", Column C = "Widget2"
Group 5 - Column A = "Line 1", Column B > "January 1, 2012", Column C = "Widget5"

2. ## Re: How to define multiple groups with data in the same column

Hi

Example workbook time, with expected output in a graph. I can't tell from your example if these are 5 rows of data or starts of blocks of data. And there doesn't seem to be any data to graph.

rylo

3. ## Re: How to define multiple groups with data in the same column

Starting with a spreadsheet full of data. In Column "A" contains the "production line" , column "B" contains the "production date", Column "C" contains the "Product" and column "D" contains the response data.

Here is how it would look :

Line 1 1/21/12 Widget1 0.5
Line 2 1/21/12 Widget2 0.5
Line 3 1/21/12 Widget4 0.5
Line 4 1/21/12 Widget1 0.5
Line 5 1/21/12 Widget5 0.5
Line 1 1/21/12 Widget1 0.5
Line 1 1/21/12 Widget1 0.5
Line 2 1/21/12 Widget2 0.5
Line 3 1/21/12 Widget4 0.5
Line 4 1/21/12 Widget1 0.5
Line 5 1/21/12 Widget5 0.5
Line 1 1/21/12 Widget1 0.5
Line 1 1/21/12 Widget1 0.5
Line 2 1/21/12 Widget2 0.5
Line 3 1/21/12 Widget4 0.5
Line 4 1/21/12 Widget1 0.5
Line 5 1/21/12 Widget5 0.5
Line 1 1/21/12 Widget1 0.5

4. ## Re: How to define multiple groups with data in the same column

Please use some imagination here....the data isn't all 0.5 and assume there are thousands of rows. Also, I am using Excel 2010.

There are currently 1 users browsing this thread. (0 members and 1 guests)