Graphing only some of the data?

G

Guest

I have a spreadsheet with groups of repeating rows and cells that look something like this
1AA 1AB 1A
1BA 2BB 2B
1CA 1CB 1C

2AA 2AB 2A
2BA 2BB 2B
2CA 2CB 2C

The rows/cells beginning with "1" make up one batch of data. The rows/cells beginning with "2" make up another. I add a new batch every week. I want to create a graph that captures only 1CC, 2CC, 3CC, 4CC, etc. There are always the same numbers of rows between the cells. I've thought about capturing 1CC, 2CC, 3CC, etc in a list in another area of the spreadsheet and graphing that list, but I don't know how to programmatically extract only those cells. Does anyone have an idea how I can do this?

Thanks
JRG
 
G

Guest

Hopefully, I'm understanding properly.

You could make a new column called "Include in Chart?"
that has a 1 or a 0 (for example) value in it. You could
either manually populate, or do so with a formula if you
can.

Then, create a chart based on the third column (the one
that has your "CC" data in it. If you create a filter
on your new "Include in CHart?" column and filter on "1"
(or yes, whatever) your chart will change to only show
those rows which cleared your filter.

I'm having trouble getting my chart to update (see my post
above), but if you use a basic filter (which should do the
trick) I think you'll be fine.

Hope this helps,
Jessica
-----Original Message-----
I have a spreadsheet with groups of repeating rows and
Click to expand...
cells that look something like this:
1AA 1AB 1AC
1BA 2BB 2BC
1CA 1CB 1CC

2AA 2AB 2AC
2BA 2BB 2BC
2CA 2CB 2CC

The rows/cells beginning with "1" make up one batch of
Click to expand...
data. The rows/cells beginning with "2" make up another. I
add a new batch every week. I want to create a graph that
captures only 1CC, 2CC, 3CC, 4CC, etc. There are always
the same numbers of rows between the cells. I've thought
about capturing 1CC, 2CC, 3CC, etc in a list in another
area of the spreadsheet and graphing that list, but I
don't know how to programmatically extract only those
cells. Does anyone have an idea how I can do this?
 
T

Tushar Mehta

So, what do you want to graph? What's on the x-axis? On the y-axis?
There must be some number(s) somewhere that you want to graph. Or,
maybe, not?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004
 
G

Guest

Doh! Good question. The horizontal axis will be time. The vertical axis will be the value of 1CC, 2CC, 3CC, etc. I think I can handle the graphing part, but I need a way to programmatically collect only those values from the repeating tables I described below
JR

----- Tushar Mehta wrote: ----

So, what do you want to graph? What's on the x-axis? On the y-axis?
There must be some number(s) somewhere that you want to graph. Or,
maybe, not

--
Regards

Tushar Meht
www.tushar-mehta.co
Business solutions leveraging technolog
Microsoft Most Valuable Professional (MVP) 2000-200
 
Top