Jon Peltier has instructions for a dynamic chart:

http://www.peltiertech.com/Excel/Cha...micLast12.html

Heydilbert wrote:
I'll try to simplify things as much as possible.

I currently have a numerically ordered list.
I need to only display the list up to a certain number.
The certain number which I need to list up to changes depending on
other variables.

I also need to display this restricted list in a graph/chart.

I could conditionally format the list to only display numbers in a
readable font colour up to the certain number, however when i then put
the data into a chart, the values which are unreadable on the worksheet
(e.g. because they are the same colour as the background) are displayed
in the graph.

Any assistance would be appreciated!




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html