• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Y-axis containing #N/A data; need to show only real items in graph

O

orbman1

New Member
Hi,


My issue is when creating a graph I am not specifying exact cells, rather I am selecting whole columns (this example A:C). My data contains some #N/A; the #N/A is being brought through to the graph on the Y-axis. I need to figure out how to graph the data (using column selection, not cell selection) and have the graph disregard #N/A.


Please let me know if anyone has a clue how to fix. Thanks


Please see picture of problem here: http://picturepush.com/public/12407943
 
Hi,

Welcome to the forum.


Due to firewall restrictions on my side, I am not able to see the picture you posted.


However, if you have not tried it already, I would encourage you to try the Custom Google Search on the top right side of this window, with a search string like "dynamic charts". You will find multiple articles that discuss creating the chart data using formulas (which can discard #N/A values, etc.)


Cheers,

Sajan.
 
You must log in or register to reply here.
Back
Top