Should have put the link in ;-0 http://www.juiceanalytics.com/writing/2007/05/why-make-100-charts-when-one-will-do/ Then so that you can see data lines for all days there is a link in the blog from Derek http://www.branta.demon.co.uk/infographics/Baseball_offset_2_derek.xls Cheers -- Mifty "Mifty" wrote: Hi, Check out this link and see if this type of representation
singhals wrote: Hugh Watkins wrote: singhals wrote: I have several family members who appear in two or more published family histories, each of which assigns an ID number. These include, but are far from limited to, these publications: 1. Kuykendall, George Benson, (1843-) : History of the Kuykendall family since its settlement in Dutch New York in
To reference addresses in cells, you'd have to use INDIRECT, and that can be unreliable when used as chart series data ranges. Use OFFSET, assume that you're offsetting from A1, and include parameters for RowOffset, ColOffset, NumRows, and NumCols (the other parameters for OFFSET). You can't do it all at once, you need a name for each set of X values and Y values (though is the same X values
Thanks Shane. Unfortunately I cannot try your suggestion because I am only equipped with Excel 2000. "ShaneDevenshire" wrote: Hi, If you are using Excel 2003 or later it might be easier to define the range in the source workbook as a List. To do this open the source workbook and select the entire data area including one row of titles. Then press Ctrl L and hit OK
Thanks Jon. Is there a way to do the same thing for multiple data series? I know I can one at a time maunually assign names to formulas that reference the the x and y values. But can I do so in "one fell swoop"? For example, I would write cell ranges in columns. Cell A1 would contain the text "C1:C100", A2 "F1:F100", etc. Similarly, column B would contain textual references to y
