HI,
I have a "Usage" chart which is taking values from cell range C3:D38. The chart is displaying #N/A values which i don't want to be displayed.
I don't want the user to manually adjust the cell range to C3:D11 and i would want a formula that would automatically detect the range of values for the chart ie start from Cell C3 and stop at the last non blank cell value so that when new data gets added to "Data" tab, then the new values get included in the chart.
How do i remove #N/A's from the chart and how do i teach the chart to auto detect the range of cells with values and not include blank or #N'A values.
Bookmarks