USE DISJUNCT DATA IN A CHART

[Takeadoe]

DATA LOOKS LIKE THIS

A B C
YEAR COUNTY ESTIMATE
1981 ADAMS 100
1981 ALLEN 25
1981 ASHLAND 71
1981 ASHTABULA 40
1982 ADAMS 150
1982 ALLEN 30
2005 ADAMS 1000
2005 ALLEN 500

I HAVE 88 COUNTIES AND 25 YEARS OF POPULATION ESTIMATES. FOR EACH
COUNTY I WANT A SIMPLE X*Y LINE CHART, YEAR ON X, ESTIMATE ON Y.
PROBLEM IS, THE POPULATION ESTIMATES FOR EACH COUNTY ARE 88 ROWS APART.
FOR ADAMS COUNTY, I WOULD NEED C1, C89, C177, C265, ... FOR ALLEN IT
WOULD BE C2, C90, C178, C266... AND SO ON. I CAN'T GROUP THE COUNTIES
BECAUSE THERE ARE FORMULAS IN THE CELLS WITH NAMED RANGES AND
EVERYTHING WOULD BE GARBAGE IF I REARRANGED THE ROWS.

CAN SOMEONE HELP ME FIGURE OUT HOW TO EXTRACT EVERY 88TH ROW, BEGINNING
WITH ROW 1 AND THEN 2 AND 3, AND CONTINUING THRU ROW 88?

I WOULD BE INDEBTED. I'VE INVESTED WAY TOO MUCH TIME ALREADY FOR THIS
TO FLOP NOW.

THANK YOU.

MIKE

 

[Bernie Deitrick]

Mike,

If you have Excel XP or greater (and possibly Excel 2000 - I forget) you can use a Pivot chart to do
what you want, with Year as a row field, County as the column field, and Estimate as the data.

HTH,
Bernie
MS Excel MVP

 

[Takeadoe]

Bernie - I think you may have something there! I forgot about the
pivot table! Your time is appreicated.

Regards,

Mike