Unwanted graph data for future values.

[Canus]

Hey.

I have a graph that shows values from future cells that haven't been calculated yet and are listed as 0.

=SERIES(,,Cash!$E$10:$E$111,1)

Is there a formula to show only the values that are above 0?

[Andy Pope]

the future cells should return #N/A for charting purposes.

Otherwise look into using dynamic named ranges for the chart data series.

[Canus]

the future cells should return #N/A for charting purposes.

Otherwise look into using dynamic named ranges for the chart data series.

Hi Andy,

The future cells return values of 0 on the graph showing a massive nosedive, then a very long line of 0's. There are formulas in the future cells that will be updated daily which I would like the graph to represent, without the additional 0s thereafter.

Im not familiar with "dynamic named ranges" how would I go about this to solve my problem?

Cheers.

[Andy Pope]

Try searching the forum for dynamic named ranges.
This charting question gets asked at least twice a week and has been answered many many times.