How can I make the graph ignore blanks

[Dayski147]

How can I make the graph ignore the spaces in the table below the file

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[Jon Peltier]

Your chart has no X values, for one thing. For another, some of the "blank" cells have a zero in them, but the display options for the worksheet are not to show zeros in cells with zero values. Also, column A has labels for some rows which are "hidden" by using white font color. All of these make it hard to track down issues. Especially the white font.

In general, if you have gaps in the data, you will get gaps in the chart.

You could turn BB101:B149 into a Table using Ctrl+T, then filter one of the columns W1, W2, or W3 so that you do not display blanks. This will make the blanks in the chart disappear.

 

[Dayski147]

Well is there a vba code that enables me to convert an equation except a blank in the case that the cell has no values only and then put a condition in the code that if there is an empty row it will be removed

 

[Jon Peltier]

Well is there a vba code that enables me to convert an equation except a blank in the case that the cell has no values only and then put a condition in the code that if there is an empty row it will be removed

You would have to write something specific to your situation.

 

[Dayski147]

Hello the problem has been solved now I need help with the vba code can you help me please