Developing and plotting data in Excel.

  • Thread starter brad sue
  • Start date
  • #1
281
0
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:

Answers and Replies

  • #2
ChrisLeslie
Try:
row 1 = 0
row 2 = row 1+1
row 3 = row 2+1
etc etc by drag duplicate formula
 
  • #3
Integral
Staff Emeritus
Science Advisor
Gold Member
7,201
56
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.
 

Related Threads on Developing and plotting data in Excel.

Replies
8
Views
43K
Replies
5
Views
10K
Replies
9
Views
925
Replies
20
Views
1K
Replies
1
Views
599
Replies
7
Views
1K
Replies
2
Views
236
Replies
10
Views
808
Top