"Jon Peltier" wrote in message
...
You need a dynamic chart. Try this:
http://peltiertech.com/Excel/Charts/DynamicLast12.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
I knew there must be a way! Very many thanks.
V