Unable to remove the blank points from the chart

[sunilbsrv2k]

Hi,

I am working on a chart based on dynamic range.

I have referred to :

and created the chart, though I have it columnwise

I am able to eliminate the dates with blank data in between.

Unfortunately, since its a dynamic ranges, the Graph is displaying the blank cells at the end.

Could you please help me in solving this issue.

I tried the option "Hide /Display empty cells". Its still persisting.

Thanks
Sunil

 

[JLGWhiz]

The only way I know to do it for sure is to eliminate those cells from your data series, but then your Row Source Range would not be dynamic, you would have to edit the series each time your data changed making different cells empty.