Automatic Update of Charts

[Chuck]

I have created a chart that should automatically update. However, some of
the more recent data is not being displayed. The OFFSET formula seems to be
correct, but shows that only a portion of the range is selected to be
displayed instead of all of the cells that contain values. Does anyone have
a suggestion regarding this problem? Thanks.

 

[Jon Peltier]

Chuck -

Without seeing the formula or a sampling of the data, we can only guess at the
problem. But this is a common fix: If the OFFSET uses a COUNT or COUNTA, it will
decide how long to make the range. But if there are spaces, they aren't counted by
COUNT/A, but may be included in the OFFSET.

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

 

[Chuck]

Thanks. There were no blank cells in the actual dataset, however blank rows
at the beginning of the column caused the data to not display correctly.
Here is the formula in question for your reference.

=OFFSET('FF data'!$C$223,0,0,COUNTA('FF data'!$C54:$C60000)-169)

$C54:$C60000 in the formula used to be $C:$C, however there were blank rows.
In addition, the graph did not start with data until row 54.