Dynamic Charts

  • Thread starter Thread starter ramsdesk
  • Start date Start date
R

ramsdesk

Say I have a set of data with 4 rows & 5columns and I have drawn a ba
chart using this data.

Suppose if I add a new row or a column at the end or to the righ
respectively, I have to change the source data of the graph to ad
these data. Is it possible to do this dynamically?

Another question:

Is it possible to avoid displaying null data in the graph?

Thanks in advance
 
Don has given a great answer but if you are using XL2003 these is another
way.
Make your data a List (read Help). Charts based on Lists are automatically
updated.
 
Null data: If it's a true blank cell (not "" returned by a formula), go to Tools
menu > Options > Chart tab, and choose the appropriate option for Plot Empty Cells
As. If it's "" in a formula, change the "" to NA(). This puts an ugly #N/A error in
the cell (hide it with conditional formatting:
http://contextures.com/xlCondFormat03.html#Errors on Debra Dalgleish's site), but
most charts will simply interpolate over this error. Area, column, bar, and surface
charts still plot NA() as zero.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top