JimS
01-23-2009, 11:03 AM
I have a Line Chart that uses Names Ranges as the Source(s) because the number of entries (rows) can vary greatly in my data set (anywhere from 10 to 100 entries/rows).
How can I have the Line Chart expand down as more entries are entered?
The Chart will show the new entries but you cannot read the Labels beacuse they are to small and appear almost on top of each other becasue the Chart does not "physically" expand down automatically.
Is there a way to have a chart's physical "size" change automatically to allow for new entries so that the Labels are readable?
ie: overall chart height = .x for each row, where x is a constant height setting?
Thanks for any and all help...
Jim
How can I have the Line Chart expand down as more entries are entered?
The Chart will show the new entries but you cannot read the Labels beacuse they are to small and appear almost on top of each other becasue the Chart does not "physically" expand down automatically.
Is there a way to have a chart's physical "size" change automatically to allow for new entries so that the Labels are readable?
ie: overall chart height = .x for each row, where x is a constant height setting?
Thanks for any and all help...
Jim