creating range for chart

[tony_bender]

I have an Excel application that returns relevant data into a table
that has a set number of columns but the rows may vary. I have a
corresponding graph based on the results. The problem is when the
number of rows returned is more or less than the original, so my graph
is incomplete.

Presently the 'source' data for the graph reads

y1 axis =Report!$C$7:$C$12
y2 axis =Report!$B$7:$B$12
x axis labels; =Report!$A$7:$A$12

This graphs fine if I have exactly 6 rows of data, but if I have more
the chart does not recognize these.

How would I program this so the chart knows to expand or contract based
on the number of rows with live data?

Thank you,

Tony B

 

[Guest]

You can use dynamic named ranges for you data, and use that names as the data
sources. For some examples on dynamic named ranges you may check:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Hope this helps,
Miguel.