Charting only populated cells within a chart range

[dano1352]

I have a chart which has a data range of M$2:M$200, but often only some of the cells will be populated and the rest would be blank. I want the chart to ignore the empty cells and only chart up to the ones that are populated.

Thanks.

 

[Scott T]

The chart will not drop to zero if you have error values instead of 0 or blank

see
https://youtu.be/W-QAx3_kL30

 

[dano1352]

Thanks Scott but I need the column chart to ignore the empty cells completely. Even though me data range is M$2:M$200 there may only be data in cells from M$2 to M$150 leaving 50 cells empty.

I don't want the chart to show 50 columns with a value of zero. ​

I only want the chart to go up to M$150. I hope this helps clarify it a bit. Perhaps there is another way to achieve what I'm trying to do? I don't know.

Thanks again.

 

[Scott T]

You need to create a dynamic range
see
https://trumpexcel.com/dynamic-chart-range/

 

[dano1352]

I suspected there was another way. Thanks Scott!