Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Developing and plotting data in Excel.

  1. Apr 21, 2007 #1
    Hi ,
    I want to create a simple series which give me the following:

    0
    1
    2
    3
    4
    5
    .
    .
    .

    from the cells.
    Please can some help me with it?

    what I really doing is:


    I have a set of numbers which represent voltages (of a nodes) inside a dielectric.
    say:

    0.854
    0.756
    0.659
    0.589
    0.458
    0.365
    0

    I want to plot them as the voltage for y axis , and X for x axis.
    So I need to make them correspond like this:


    VOLT X
    0.854 6
    0.756 5
    0.659 4
    0.589 3
    0.458 2
    0.365 1
    0.000 0

    I need to create this colum ( on the side ) to be able to plot the different voltages.
    The voltages are computed at the nodes that have distant each other by delta=1/N where N is the number of rows(here 7).
    I don't know if this information is relevant to solve this isue.

    Thank you
    B
     
    Last edited: Apr 21, 2007
  2. jcsd
  3. Apr 22, 2007 #2
    Try:
    row 1 = 0
    row 2 = row 1+1
    row 3 = row 2+1
    etc etc by drag duplicate formula
     
  4. Apr 22, 2007 #3

    Integral

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    It is not clear what you question is?

    you can start a pattern then grab the black square which will appear in the lower right hand corner to do a auto fill. Once you have the columns you need, select them and pick SCATTER PLOT from the chart type menu.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?