Graphing non adjacent cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a scatter plot of the following cells:

A1 thru A10801 every twelfth row that is A1,A13,A25,A37 ... A10801

as the x axis

and

C7 thru C10807 every twelfth row that is C7,C19,C31,C43 ... C10807

as the y axis.


How do I do it?

Thanks in advance.
 
Hi struggling_with_excel,

An easy way to chart non-adjacient cells is to create a range that contains
formulas that reference the cells you wish to chart, then chart that range.

In the situation you describe, the trick is to write formulas that point to
every twelfth row in columns A and C.

Here is one way to do it.

I will assume that the original data is in Sheet1, if you have a different
sheet name, just replace "Sheet1" in the formula below to your own sheet
name.

Open a new worksheet.
Enter 12 in cell A1 - this sets the row increment.
Enter 1 in cell A2 - this is the starting row you wish to chart.

Enter the formula =A2+$A$1 in cell A2 and copy down from A2 to A902
Enter the formula =INDIRECT(ADDRESS(A2,1,,,"Sheet1")) in cell B2. Copy down
to B902

Chart the range A2:B902

Ed Ferrero
 
Back
Top