Re: Automatic Update of Charts
From: Chuck (Chuck_at_discussions.microsoft.com)
Date: 10/13/04
- Next message: sue t: "Combination Chart"
- Previous message: Room 210: "How do I create a topographic map using Excel?"
- In reply to: Jon Peltier: "Re: Automatic Update of Charts"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 13 Oct 2004 11:21:03 -0700
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.
"Jon Peltier" wrote:
> 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 wrote:
>
> > 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.
>
>
- Next message: sue t: "Combination Chart"
- Previous message: Room 210: "How do I create a topographic map using Excel?"
- In reply to: Jon Peltier: "Re: Automatic Update of Charts"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
