Creating Line Chart

Discussion in 'Mac Apps and Mac App Store' started by 1365281, Aug 11, 2007.

Most Liked Posts
  1. 1365281, Aug 11, 2007

    1365281 Suspended

    Joined:
    Oct 27, 2006
    #1
    Hello,

    how does one create Line Chart in Excel?
    I have two series of data(one for X values, the other for Y values): just need to plot one in function of another and get ONE line. Instead, I'm getting EACH of the series plotted (as Y values) in function of number of lines of the spreadsheet. Tried to read Help section, still don't have an answer.
    Thanks in advance
     
    share
    + Quote Reply
  2. xUKHCx, Aug 11, 2007

    xUKHCx Administrator emeritus

    xUKHCx

    Joined:
    Jan 15, 2006
    Location:
    The Kop
    #2
    The way i understand you question, the answer would be to actually use the XY scatter option for your graph rather than the line chart option. You can have lines connecting the data points and you have the flexibility to choose the data in the "series" tab in the second window of the chart wizard.

    Of course i may have totally read your question wrongly.
     
    share
    + Quote Reply
  3. Analog Kid, Aug 11, 2007

    Analog Kid macrumors 601

    Analog Kid

    Joined:
    Mar 4, 2003
    #3
    I think what you want is a scatter plot.
     
    share
    + Quote Reply
  4. 1365281, Aug 11, 2007

    1365281 thread starter Suspended

    Joined:
    Oct 27, 2006
    #4
    Thank you so much!!!
    It worked!!!
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page