Dynamic Graph, Do Not Want X-Axis to Plot Blank or Zero Values

I working with a dynamic graph that uses the following formula to define the X-Axis ("Fast" is the name of a specific sheet within the book). The dataset the formula is looking at will frequently have either no data or "0" as the value. I would like to edit this formula such that the graph does not plot anything if one of these condition is present. I have seen solutions recommending the use of NA(), but I cannot figure out how to change my formula. Can anyone help?

[=OFFSET(Fast!$A$1,1,0,COUNTA(Fast!$A:$A))]

Thanks in advance for your time! Tisha

Hi, I appreciate the quick response! Ultimately, this file would be used be multiple people with varying datasets. Often datasets may be incomplete or of varying sizes; I need this graph to accomodate any situation and appear as if there no missing data. So, yes, if there are 5 lines of data, I only want to see 5 items on the graph instead of a bunch of zero data points.
I have attached an example of my graph. Please let me know if you need further clarification. Tisha

I like it! My method was kluged together, so I am not suprised there are much better ways. It took be a bit to figure out what was going on (with your file), but I think I have a pretty good idea. The only thing I don't understand now is why drop down is not switching between ROP and Distance. If you can help with that, I this problem will be resolved.

I really appreciate your time with this! This little project has really taught me several new things.

So, I have previously thought of myself as reasonably savvy with Excel (at least in my circle of engineers), but I am definitely in my place. You are correct, in attempt to strip my actual file of confidential data, I mislabeled a ROP/RPM (It should have been labeled ROP). My goal is to allow users to switch between ROP and Distance (on the Y-axis), with Type on the X-axis. In addition, I need the X-axis to only show data points that actually contain data (which you helped me accomplish).

I have reattached my working file. This file contains the necessary corrections.
Again, I sincerely appreciate your help and patients with this!

Hi Tisha, Jeff,

In the excel files you have shared, you have used "=Chart2.xlsx!Myrng" for chart values. Could you please tell me where have you defined the values of "Myrng". Or where can I find it? Because, I've a similar problem.

Thanks in advance,
Nivi

Thanks Jeff,

That helped me.... I just followed this post as, it will be easier for me to explain my problem.... Will surely post new threads on my new doubts.... Thanks again....

Nivi

Hi,
This is posted some time after the last message posted, but I have been following this thread and it has been useful. One question I had, the drop down box to select the chart title & ranges on the chart - 'distance drilled' or 'ROP', how is this set up and what named ranges does this refer to, and how is the chart reconfigured each time when the user chooses the selection? I'm hoping to prepare a similar chart for UK 2011 census data, either a total numbers chart or a % chart.
Many thanks,
Jonathan