Hi,

Depends on the version of Excel you are using, let's suppose 2003 - select
the range where the data will appear on the Sheet1, for example A1:D29 (one
row for titles and 28 rows for the minimum number of rows needed for Feb.).
Choose the command Data, List, Create List and click OK.

Now create your chart and select this list range. When you add more data
for 30 and 31 day months the chart wifll automatically expand to chart the
range.

--
Cheers,
Shane Devenshire


"SA Roberts" wrote:

I am trying to build a standard sheet with a chart. This chart may contain
28, 29, 30 or 31 rows depending upon the number of days in the month the
chart is prepared. A database application loads the data into Sheet1, and
sheet two contains the graph. The graph always shows 31 days. Sheet1
contains a cell stating the number of days to chart but I am, so far,
unsuccessful in using a formula or expression when stating the series range
in the chart data properties. It seems the only expression the chart
understands is a static range of cells. Because of security restrictions on
desktops I am trying to avoid VBA and would prefer a formulaic solution.
--
Thx,
SA Roberts