Stop Chart Plotting at 0 when variable is not part of data series

**andyfive** · 02-21-2012, 02:09 PM

Hi,

I am trying to plot a chart to represent the flight of a ball through the air. I have three sets of data points representing the X (Distance), Y (Direction) & Z (Height) coordinates of the ball as it flies through the air. I am trying to plot two sets of data series namely X against Z (to represent the distance/height) and X against Y (to represent distance/direction). I want the graphing to stop when the ball hits the ground (i.e. when Z = 0). I can do this OK when charting X against Z but do not know how to do it when charting X against Y (when Z is not a variable in the Data Series). Can anyone please offer any help.

Many Thanks,

Andy.

**andyfive** · 02-21-2012, 07:02 PM

Hi,

Just thought I would post an image to help illustrate my problem :

Ball Flight Graph.JPG

I would like the red 'Direction' Line to stop at the same point as when the blue 'Distance' line reaches a height of 0.

Many Thanks

Andy.

**shg** · 02-21-2012, 07:08 PM

This is an Excel forum, so you'll get more efficient assistance if you post workbooks rather than pictures.

You can change the direction formula to something like

=if(z<=0, na(), the rest of the formula)

**andyfive** · 02-21-2012, 07:45 PM

Hi shg,

Many Thanks for your reply. Please find attached the spreadsheet I am working on. The Graph data is from columns S, T & U derived from columns D, E & F which are in meters. I think your suggestion will work although this may not produce a 'True' 0 but rather the data point prior to 0. I'll give it a try.

Cheers

Andy.