Thread: Excluding data from automatically refreshed charts

How do I exclude the last three rows of a graph that is automatically
refreshed?

Really,

You can change the source data to not include the last three rows. A macro
could do that. Or you could use Tools - Options - Chart - Visible cells
only, and hide the rows .
--
Earl Kiosterud
www.smokeylake.com

"Reallydumb" <Reallydumb@discussions.microsoft.com> wrote in message
news:943F89DC-9B54-4F9C-AF91-337C84E77C04@microsoft.com...
> How do I exclude the last three rows of a graph that is automatically
> refreshed?

In article <943F89DC-9B54-4F9C-AF91-337C84E77C04@microsoft.com>,
Reallydumb@discussions.microsoft.com says...
> How do I exclude the last three rows of a graph that is automatically
> refreshed?
>
In addition to Earl's suggestions, you could also used a named formula.
See
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions