Graphing data not yet entered

[Guest]

When I make up a simple line graph (such as graphing names and ages), I can
define the source data with mty cells at the end.

For example, if I have 5 names and 5 ages, that go in cells A1:A5 and B1:B5,
respectively. In my graph, I have the source data for the names defined as
A1:A10 and ages defined as B1:B10. This obviously includes blank cells.

The graph works fine, as I feel in additional names and ages. The line
extends out appropriately.

But when I have a graph that should have several lines, I am unable to pull
off the same trick. If I include blank cells in the source data, that
particular line disappears.

What am I missing?

Thanks,

Rich

 

[Guest]

Is this link of help?

www.ozgrid.com/Excel/DynamicRanges.htm

 

[Guest]

No, unfortunately, not . . . Excel seems to have built in behavioir where
that I don't need the offset formula (I also ran into that solution on
j-walk's site).

It's weird; if I include blank cells at the end of the source data range,
the graph line completely disappears.

Thank you very much . . .

Rich

 

[Jon Peltier]

To make it easier for Excel to figure out what you want to plot, adjust your
data range slightly. Insert a row at the top, so the data points begin in
row 2. In row 1, leave the cell above the names blank, but add a label above
each column of values. The blank cell tells Excel that the first column and
the first row are different, and it uses the first column as category labels
and the first row as series names. Without this data structure, you are
never sure what you may get.

- Jon