+ Reply to Thread
Results 1 to 5 of 5

Creating Chart from Row of data

  1. #1
    Registered User
    Join Date
    10-26-2008
    Location
    dublin
    Posts
    10

    Creating Chart from Row of data

    Hi There

    I have a row of data going from D1:D50

    Within this data is users who have said there demographic information of being either Female or Male.

    Is there any way to build a chart from this data so that you can see X many Female versus X many Male?

    Its been driving me nuts

    Any help really appreciated

    Cheers
    Remo

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    It's a single number, the ratio of females to males -- what's to chart?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-26-2008
    Location
    dublin
    Posts
    10
    Because its not a fixed number as grows daily (sorry If I wasnt being clear, I was just trying to simplify)

    Tomorrow it will be 100, by next Wednes 200, its a growing daily figure with a variation of how many rows within the column are labelled either F or M

    If it was only 50 yes I could just do the math

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610
    Why can't you use a couple of cells that count the m's and f's? Have you looked at COUNTIF()?
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    10-26-2008
    Location
    dublin
    Posts
    10
    Countif() , was what I was looking for !

    Thanks for the suggestion, I'm a newbie of the forum so thanks for the help.
    I always prefer being pointed in the right direction, and countif answers a couple of other Qs I have

    Cheers

+ Reply to Thread

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