Results 1 to 4 of 4

Thread: Charts

  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: Charts

    hi,
    Excel2k
    win2k, xp

    I want to build and graph a chart in excel that takes the values bellow but I can not do it Can anyone help? Y and X values are integres, not percentage or dates.

    Y X

    1 =
    2 =
    3 = 1
    4 = 1
    5 = 1
    6 = 6
    7 = 5
    8 = 8
    9 = 6
    10 = 10
    11 = 2
    12 = 3
    13 = 8


    13
    12
    11
    10
    9
    8
    7
    6
    5
    4
    3
    2
    1______________________________
    1 1 1 6 5 8 6 10 2 3 8

    The X values are dynamic; that is, they change.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Can you post a sample file, with your data table? It's a little hard to visualize how your data is set up. Thanks.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    charts

    here is the example.
    Attached Thumbnails Attached Thumbnails untitled.bmp  

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    I assume you want an XY Scatter chart? Here is one possibility, if I understand you correctly.
    Attached Files Attached Files
    Last edited by shades; 02-03-05 at 15:02.

Posting Permissions

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