Developing and plotting data in Excel.

[brad sue]

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

 

[ChrisLeslie]

Try:
row 1 = 0
row 2 = row 1+1
row 3 = row 2+1
etc etc by drag duplicate formula

 

[Integral]

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.