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