Conditional Chart/Graph?

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!

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