Conditional Chart/Graph?

[Heydilbert]

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 o
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
readable font colour up to the certain number, however when i then pu
the data into a chart, the values which are unreadable on the workshee
(e.g. because they are the same colour as the background) are displaye
in the graph.

Any assistance would be appreciated!
*Conditional Chart/Graph?

 

[Bryan Hessey]

Option 1

Assuming your data is in column A, you could insert a start row number
in B1 and a finish row number in B2 and use the formula

=IF(AND($B$1<=ROW(),$B$2>=ROW()),A1,"")

in C1 and formula copy enough rows to match the data in column A, and
then chart from Column C

I don't know how to make the chart range variable to prevent the blank
area at the start and end of the chart, but only required data will be
displayed.

Hide columns A & B if required.


Option 2

same data in column A, but for a fixed number of cell display, (ie, if
you always want to display only 12 items) in B1 the start row, in B2
the number of rows

Set the chart to C1:C12

In C1 the formula

=IF(ROW()<=B$2,OFFSET(A$1,ROW()+B$1,0),"")

and formula copy down to cover the maximum number of rows that you
will ever chart.

Then chart from the C column.


Hope this gives you some idea.