Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel Graph

0 views
Skip to first unread message

Fay

unread,
Nov 25, 2009, 1:10:01 AM11/25/09
to
Hello,

Need help with a dynamic graph. I am using a defined names to automatically
update a chart range but I want the number of horizontal data points to be
fixed at say 10 data points. I want to truncate old data points and add the
newest each time a new entry is made.

Thanks

Andy Pope

unread,
Nov 25, 2009, 6:42:33 AM11/25/09
to
Hi,

This page describes the last 12 months. You should be able to modify for
your needs.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Fay" <F...@discussions.microsoft.com> wrote in message
news:2210A2B9-73B1-4049...@microsoft.com...

ryguy7272

unread,
Nov 25, 2009, 8:27:01 AM11/25/09
to
Tons of ideas here:
http://peltiertech.com/Excel/Charts/ChartIndex.html
http://www.andypope.info/charts.htm

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Andy Pope" wrote:

> .
>

0 new messages