dynamic data range and series

[Cass Calculator]

I am doing regression analysis for tree size (independent variable)
and tree age (dependent variable). I want to make a template that
will allow me to chart a dynamic number of trees (data points) and
tree types (series) on a scatterplot. So, I have three columns:
dependent, independent, and tree type.

I want to generate a scatterplot on X and Y axis that has each tree
type as a seperate series. Again, this should work for a dynamic
number of trees (data points) and tree types (series).

This template is meant to be for a given site of trees. I would like
to have the chart on a seperate worksheet. That way, when I add more
sites, I can just copy the chart and the data template, add in the new
data and be done. = )

An amazing bonus feature would also be to be able to merge all the
sites once I am done adding sites. So for a dynamic number of
workseets with a given's sites data, be able to merge all that data
into one worksheet.

I have been trying to figure this out with no luck. I greatly
appreciate anyone that can provide a solution.

Thank You !

Joshua

 

[ShaneDevenshire]

Hi,

Assuming you are using Excel 2003 or 2007: Define the input area as a list
or table, then plot that area.

2003 -
1. Add your titles and one row of dummy data
2. Place your cursor in the data and press Ctrl L, OK.
3. Create a scatter chart from this range.
4. Delete the dummy data but not the titles (you can delete the row that
the dummy data is on or you can just clear the cells.
5. As data is added to the data area the chart will automatically update to
include it.

2007 -
Same basic idea except List are now called Tables. You can use the Ctrl L
or Ctrl T keys to create the Table.

For a consolidation, if this is what you want, you can copy the data from a
list, not its titles and paste it in the first row below another list or
table and the list will expand to include both sets of data, and the chart
will update accordingly. Repeat until all sites (list) have been combined on
one sheet.

 

[Cass Calculator]

Hi,

Assuming you are using Excel 2003 or 2007: Define the input area as a list
or table, then plot that area.

2003 -
1. Add your titles and one row of dummy data
2. Place your cursor in the data and press Ctrl L, OK.
3. Create a scatter chart from this range.
4. Delete the dummy data but not the titles (you can delete the row that
the dummy data is on or you can just clear the cells.
5. As data is added to the data area the chart will automatically update to
include it.

2007 -
Same basic idea except List are now called Tables. You can use the Ctrl L
or Ctrl T keys to create the Table.

For a consolidation, if this is what you want, you can copy the data from a
list, not its titles and paste it in the first row below another list or
table and the list will expand to include both sets of data, and the chart
will update accordingly. Repeat until all sites (list) have been combined on
one sheet.

Unfortunately when you have are making a scatterplot with different
series of data, i think you have to create the series manually. Am I
wrong?

 

[ShaneDevenshire]

Hi Cass,

Why don't you show us a dummy sample of data, i'm hearing:

T X Y
a 1 3
b 2 6

I see the data points or the series but I don't see both.

 

[Cass Calculator]

Hi Cass,

Why don't you show us a dummy sample of data, i'm hearing:

T X Y
a 1 3
b 2 6

I see the data points or the series but I don't see both.

"a" is a series with coordinates (1,3) and "b" is another series with
coordinates (2,6). all data points of type a should be one series
(one color of dot on scatterplot) and all data points should be
another series (another color of dot on scatterplot)