Scatter Plot

[dharmalife87]

I need a scatter plot that will leave out any values at 0

 

[mole999]

you can tell the chart not to plot zero values (not sure where to find that, I end up searching when i need to do it)

 

[gorem]

Right click on chart > Select Data > Hidden and Empty Cells > Show empty cells as...

Should work for you. I would just replace zeros with "".

 

[dharmalife87]

Replacing the 0's won't work since the 0 values are a part of the graphs formulations. There are no empty cells so selecting that option does not make changes.

 

[gorem]

Replacing the 0's won't work since the 0 values are a part of the graphs formulations.

What do you mean by "the graph's formulations?"

 

[dharmalife87]

The 0's are making a statement in the graphs. Just for this particular scatter plot graph I do not need the 0s. Other charts and calculations need the 0s. If I remove them or change them I will mess up everything else.

 

[mole999]

how about creating a second data set i.e in z1=a1, drag out to get your data, then delete the zeros on the spare and plot that one

 

[dharmalife87]

I have thought of using a second chart with 0s deleted then hiding the chart. I am trying not to do that! :D if all else it will be my fall back option.

 

[dharmalife87]

I actually just created a 2nd table with the 0s deleted. I created the scatter plot and then I hid the extra table. The results cleared out the scatter plot. I really don't want this 2nd table since it is actually useless to me and just creates more than necessary.