+ Reply to Thread
Results 1 to 9 of 9

Using two columns - one to represent other to plot

  1. #1
    Registered User
    Join Date
    02-11-2012
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    5

    Using two columns - one to represent other to plot

    So im stuck on this graphing problem.
    i have two columns:
    1) the frequency - the number of times the data point is there
    2) the value

    How would i plot the value (column 2) on the graph column 1 many times?

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Using two columns - one to represent other to plot

    This doesn't make all that much sense to me. Do you have a sample workbook and a little cleared explanation of what you are trying to achieve?
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    02-11-2012
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Using two columns - one to represent other to plot

    Jeffrey
    here is a sample work book:
    https://docs.google.com/spreadsheet/...DI3a05PbnMwQlE

  4. #4
    Registered User
    Join Date
    02-11-2012
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Using two columns - one to represent other to plot

    column B is frequency column D is value

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Using two columns - one to represent other to plot

    There is not workbook at that link for me to download.

    Why not just upload the workbook here >> Go advanced >> Manage attachments

  6. #6
    Registered User
    Join Date
    02-11-2012
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Using two columns - one to represent other to plot

    ive attached it. column b is the number of times column d appears.
    Attached Files Attached Files

  7. #7
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Using two columns - one to represent other to plot

    B1 = 75400000
    D1 = 95

    I do not see how this adds up. Please give me some more finite explanation

  8. #8
    Registered User
    Join Date
    02-11-2012
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Using two columns - one to represent other to plot

    B1 = 75400000
    D1 = 95

    means the value 95 was found 75400000 times.
    So the x axis would be 1-n
    while the y axis would be column D with frequency column B

  9. #9
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Using two columns - one to represent other to plot

    To be quite honest this has me stumped so hopefully somebody else will come along

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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