Excel 2008 Help!

Discussion in 'Mac Basics and Help' started by nayan504, Feb 8, 2010.

  1. nayan504 macrumors member

    Dec 17, 2009

    I have been trying to plot a simple line graph in excel 2008, using two columns, one with my x values and one with my corresponding Y values. However I cannot do it..it will not let me put the data together but rather has two separate lines for each column...or it will have all points in a straight vertical line...i am really confused on why it is so difficult to make a simple graph

  2. nadyne macrumors 6502a

    Jan 25, 2004
    Mountain View, CA USA
    It depends on your data as to which one will work the best, but ...

    1. If both your X and Y are numeric, select both your X and Y data and insert an XY (scatter) chart -- probably either the straight marked scatter or straight lined sccatter.

    2. Select only your Y data. Insert your line chart type. In the formatting palette, choose "chart data", then "edit", and enter a reference to the X data in the "category axis labels" box.


Share This Page