software

I have a database on sheet quot;Dquot; with 1000 rows of data 79 columns wide.

How do I create a single line chart on sheet quot;Aquot; that graphs a single row on
sheet quot;Dquot; where the row number is specified in cell H1 on sheet quot;Aquot;

This doesn't work:
=D!amp;ADDRESS(OFFSET(A1,H1,1,1,1),1):ADDRESS(OFFSET( A1,H1,1,1,1),78)

The chart would graph out whatever D! row number is pointed to by cell A1 on
sheet quot;Aquot;

read other posts today

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Nick Krillquot; gt; wrote in message
...
gt;I have a database on sheet quot;Dquot; with 1000 rows of data 79 columns wide.
gt;
gt; How do I create a single line chart on sheet quot;Aquot; that graphs a single row
gt; on
gt; sheet quot;Dquot; where the row number is specified in cell H1 on sheet quot;Aquot;
gt;
gt; This doesn't work:
gt; =D!amp;ADDRESS(OFFSET(A1,H1,1,1,1),1):ADDRESS(OFFSET( A1,H1,1,1,1),78)
gt;
gt; The chart would graph out whatever D! row number is pointed to by cell A1
gt; on
gt; sheet quot;Aquot;
Bernard –
Thanks for your rapid response. I spent the better part of this morning
chasing down other posts and have not found anything that will allow me to
enter a variable for the row number in the graph range formula. I spent
considerable time trying to make something work but to no avail.
Regards,

Nick Krillquot;Bernard Liengmequot; wrote:

gt; read other posts today
gt;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Nick Krillquot; gt; wrote in message
gt; ...
gt; gt;I have a database on sheet quot;Dquot; with 1000 rows of data 79 columns wide.
gt; gt;
gt; gt; How do I create a single line chart on sheet quot;Aquot; that graphs a single row
gt; gt; on
gt; gt; sheet quot;Dquot; where the row number is specified in cell H1 on sheet quot;Aquot;
gt; gt;
gt; gt; This doesn't work:
gt; gt; =D!amp;ADDRESS(OFFSET(A1,H1,1,1,1),1):ADDRESS(OFFSET( A1,H1,1,1,1),78)
gt; gt;
gt; gt; The chart would graph out whatever D! row number is pointed to by cell A1
gt; gt; on
gt; gt; sheet quot;Aquot;
gt;
gt;
gt;

There is conflicting information in the post. First you indicate that
the row # is specified by H1; then you indicate the row # is specified
in A1.

Assuming it is H1 and that you want to plot columns 1 through 78...

Create a named formula (Insert | Name gt; Define...). Say you name it
PlotRng. It should be =INDIRECT(quot;'D'!$A$quot; amp; A!$H$1 amp; quot;:$BZ$quot; amp; A!$H$1)

Now, create a chart using this named formula.

For more help on creating a named formula or using one in a chart, see
the links in the first paragraph in
Dynamic Charts
www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;,says...
gt; I have a database on sheet quot;Dquot; with 1000 rows of data 79 columns wide.
gt;
gt; How do I create a single line chart on sheet quot;Aquot; that graphs a single row on
gt; sheet quot;Dquot; where the row number is specified in cell H1 on sheet quot;Aquot;
gt;
gt; This doesn't work:
gt; =D!amp;ADDRESS(OFFSET(A1,H1,1,1,1),1):ADDRESS(OFFSET( A1,H1,1,1,1),78)
gt;
gt; The chart would graph out whatever D! row number is pointed to by cell A1 on
gt; sheet quot;Aquot;
gt;

Tushar - Thank you for your help, your solution worked marvelously!
Nick Krill

quot;Tushar Mehtaquot; wrote:

gt; There is conflicting information in the post. First you indicate that
gt; the row # is specified by H1; then you indicate the row # is specified
gt; in A1.
gt;
gt; Assuming it is H1 and that you want to plot columns 1 through 78...
gt;
gt; Create a named formula (Insert | Name gt; Define...). Say you name it
gt; PlotRng. It should be =INDIRECT(quot;'D'!$A$quot; amp; A!$H$1 amp; quot;:$BZ$quot; amp; A!$H$1)
gt;
gt; Now, create a chart using this named formula.
gt;
gt; For more help on creating a named formula or using one in a chart, see
gt; the links in the first paragraph in
gt; Dynamic Charts
gt; www.tushar-mehta.com/excel/ne...rts/index.html
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;,
gt; says...
gt; gt; I have a database on sheet quot;Dquot; with 1000 rows of data 79 columns wide.
gt; gt;
gt; gt; How do I create a single line chart on sheet quot;Aquot; that graphs a single row on
gt; gt; sheet quot;Dquot; where the row number is specified in cell H1 on sheet quot;Aquot;
gt; gt;
gt; gt; This doesn't work:
gt; gt; =D!amp;ADDRESS(OFFSET(A1,H1,1,1,1),1):ADDRESS(OFFSET( A1,H1,1,1,1),78)
gt; gt;
gt; gt; The chart would graph out whatever D! row number is pointed to by cell A1 on
gt; gt; sheet quot;Aquot;
gt; gt;
gt;

You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;,says...
gt; Tushar - Thank you for your help, your solution worked marvelously!
gt; Nick Krill
gt;
{snip}