Results 1 to 5 of 5

trying to organize my baseball cards by 3 variables

Threaded View

  1. #1
    Registered User
    Join Date
    01-18-2006
    Posts
    7

    trying to organize my baseball cards by 3 variables

    Chart question, I am stumped:


    Column A either says "yes or no"
    Column B is the name of the player
    Columns C through Z are the years, with a number that corresponds with how many I have of that player for that year. (1987, 1988, 1989, etc)

    Kinda like this:



    ----------------------------------------------------------------------------

    A_______B_______C___D___E___F-----> Z
    sell? playername 1987 1988 1989 1990
    no Barry Bonds____4____6___2___1
    yes Ken Griffey Jr___6____1___3___3
    yes Sammy Sosa___1____1___5___2
    no Barry Larkin____1____1____2___1
    ---------------------------------------------------------------------------




    My question is, How do I make a column bar graph that adds up all of column C, all of column D, etc etc through Column Z (by the year), to produce a graph that shows:

    one axis: number of cards
    the other axis (the columns): year, but divided into the yes/no of column A.

    kinda like this:





    ---------------------------------------------------------------------------------
    n
    u
    m
    b
    e (then in here, each bar is
    r divided in two by the yes/no answer)

    o
    f

    c 4
    a 3
    r 2
    d 1
    s 87 88 89 90 91 92 93----->

    year by year


    ---------------------------------------------------------------------------------------------





    Sorry if this came off as a little confusing, but obviously I am a lot confused.
    Last edited by Kepf; 05-17-2006 at 01:22 PM.

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1