Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic data range and series
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic data range and series
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. -- Cheers, Shane Devenshire "Cass Calculator" wrote: 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic data range and series
On Feb 24, 12:08 pm, ShaneDevenshire
wrote: 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. -- Cheers, Shane Devenshire "Cass Calculator" wrote: 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 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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic data range and series
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. -- Thanks, Shane Devenshire "Cass Calculator" wrote: On Feb 24, 12:08 pm, ShaneDevenshire wrote: 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. -- Cheers, Shane Devenshire "Cass Calculator" wrote: 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 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? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
dynamic data range and series
On Feb 24, 6:00 pm, ShaneDevenshire
wrote: 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. -- Thanks, Shane Devenshire "Cass Calculator" wrote: On Feb 24, 12:08 pm, ShaneDevenshire wrote: 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. -- Cheers, Shane Devenshire "Cass Calculator" wrote: 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 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? "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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic range and series | Excel Worksheet Functions | |||
Dynamic data series | Charts and Charting in Excel | |||
Dynamic Data Range | Excel Worksheet Functions | |||
Dynamic series range from AutoFilter | Charts and Charting in Excel | |||
need help updating chart (series in dynamic range) | Charts and Charting in Excel |