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 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!
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.

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!
Conditional Chart/Graph?