+ Reply to Thread
Results 1 to 4 of 4

draw chart for range by condition

  1. #1
    Registered User
    Join Date
    09-30-2008
    Location
    Armenia
    Posts
    7

    draw chart for range by condition

    Hi all,

    I'm trying to draw chart for the range which members meet some criteria.

    Date letter count
    1-Jan-08 a 10
    2-Jan-08 a 5
    3-Jan-08 a 4
    4-Jan-08 a 8
    5-Jan-08 a 3
    6-Jan-08 b 6
    7-Jan-08 b 9
    8-Jan-08 c 7
    9-Jan-08 c 4
    10-Jan-08 c 10

    I want to draw 3 separate charts for the counts on each date for letters "a", "b" and "c" (see attached .xls file).

    TIA
    Best,
    GMara.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    That's what your example contians.

    Perhaps there is more to your request that you need to explain.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-30-2008
    Location
    Armenia
    Posts
    7
    Hi Andy,

    I drew 3 charts in excel sheet by hand, but I whant to select the whole range and give some criteria (somehow, I dont know how) and get the chart with data which satisfy to the given criteria.

    That's what I really need.
    Best,
    GMara

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    Unfortunately charts will not do that for you.

    You will need to create 3 separate sources of data for your charts using formula. I manually selected the data but if you need a more automated way search forum for Named ranges.

    See attached.
    Attached Files Attached Files

+ 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