On 8/21/2010 2:28 PM, Marcello Romani wrote:
James ha scritto:
I have 50 rows in a spreadsheet and I created a line graph.
Whenever I add a row, I need to edit the DataRang/Series in the graph.
I can't set the DataRange to a high number because then the labels on
the Y-axis have blank labels and the graph looks squished.
Is there a way to create a graph that only uses data up to the first
blank row?
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
If you insert a row before the last one instead of after it, the data
range gets updated automatically. For example, you coud insert it just
before the last row.
HTH
Marcello
I find this sort of approach works well. I just make the "last line" a
dummy that is background-colored differently and contains a reminder
that "It" should be pushed down when new data is to be added
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
