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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Takeadoe]

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

Regards,

Mike
Bernie Deitrick wrote:
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >