Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create multiple XY scatter charts
Dear friends,
I have the following sample date from a forest inventory Serial Number (1...500) Height (e.g. 13) Age (e.g. 120) I need to create XY scatter charts for each row of data? Is it possible using some code? Thanking you in advance, GeorgeCY |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create multiple XY scatter charts
I am reading this as:
You have serial numbers in one column (say A1:A500); in the next column you have Height and the next you have Age You want an XY chart of this data. Select B1:C500 and then use the Chart Wizard to make the chart. Am I missing something? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "George" wrote in message ... Dear friends, I have the following sample date from a forest inventory Serial Number (1...500) Height (e.g. 13) Age (e.g. 120) I need to create XY scatter charts for each row of data? Is it possible using some code? Thanking you in advance, GeorgeCY |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create multiple XY scatter charts
Thanks for the reply,
The problem is that I will need 500 different charts (each one showing each row of data). Ο χρήστης "Bernard Liengme" *γγραψε: I am reading this as: You have serial numbers in one column (say A1:A500); in the next column you have Height and the next you have Age You want an XY chart of this data. Select B1:C500 and then use the Chart Wizard to make the chart. Am I missing something? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "George" wrote in message ... Dear friends, I have the following sample date from a forest inventory Serial Number (1...500) Height (e.g. 13) Age (e.g. 120) I need to create XY scatter charts for each row of data? Is it possible using some code? Thanking you in advance, GeorgeCY |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create multiple XY scatter charts
On Thu, 19 Jul 2007, in microsoft.public.excel.charting,
George said: The problem is that I will need 500 different charts (each one showing each row of data). I've said it before, but who *are* these sadists who demand hundreds of charts to be made using Excel (instead of a more appropriate business intelligence package), and then address this demand to employees who (no offence George) don't know much about Excel charts!? On another tack, do I understand right, and the plan is to plot five hundred points of data (one row=one record=one data point) at one data point per chart? -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create multiple XY scatter charts
500 charts on a worksheet will hose your workbook. Here's a better way to
proceed. Assuming S/N in column A, Height in column B, and Age in column C, labels in A1:C1, and 500 records from row 2 through 501. Put the same headers in E1:G1. In E2 enter any serial number. In F2 enter this formula: =INDEX(A2:C501,E2,2) in G2 enter this formula: =INDEX(A2:C501,E2,3) These two cells will update as the value in E2 is changed. Make an XY chart using F2 as the Y value, G2 as the X value (age as independent variable makes sense, no?), and E2 as the series name. Fix the X axis so min=0 and max = longest age. Fix the Y axis so min=0 and max = tallest height. To make this work nicely, add a scrollbar from the Forms menu. Orient it horizontally, set its min to 1 and max to 500, and set its link cell to E2. Drag the scroll bar to step down the list of trees. So what good is showing one single tree on a chart? How about plotting all trees on an XY chart, then add a series as I've described above in a contrasting pattern? Then you not only see the indicated tree, but how it relates to all the others. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "George" wrote in message ... Dear friends, I have the following sample date from a forest inventory Serial Number (1...500) Height (e.g. 13) Age (e.g. 120) I need to create XY scatter charts for each row of data? Is it possible using some code? Thanking you in advance, GeorgeCY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create multiple charts using variable data? | Charts and Charting in Excel | |||
How to Automatically Create Scatter Plot Charts | Charts and Charting in Excel | |||
Use a loop to create multiple Charts - Suggestions ? | Charts and Charting in Excel | |||
XY Scatter Charts, High/Low bars, Multiple Series | Charts and Charting in Excel | |||
Create Multiple Charts w/ VB | Charts and Charting in Excel |