Chart works with 8 Columns, Fails with 9

[DarrylBurge]

I am trying to create a chart with 9 columns of data.

If I select 8 of the columns of data, the chart works perfectly well
Forum1.jpg

If I try and select the 9th column of data as well, the chart appears to fall over.
Forum2.jpg

Can anyone shed any light on this?

[Glenn Kennedy]

Can we get a sample file? Pictures don't help much.

[DarrylBurge]

Of course. Please find it attached

Another thing I noticed too, if I select all of the rows it doesn't like it, and it looks as though only the furthest right selected column, and the final row are selected.

[Glenn Kennedy]

1. Change the formulae to :

=IF('Washer 1'!D3="Fail",'Washer 1'!C3,NA())

this hides the block of zero values. If you don't like the "look" of the #N/A errors, they can be hidden by conditional formatting.

2. I started over selecting Fails!$A$2:$J$601 as the range and it worked perfectly.

[Glenn Kennedy]

And here it is, with the #N/A hidden

=ISERROR(B2) and format the text colour as white. The errors are still there, but you can't see them any more.

[DarrylBurge]

I would have been there forever trying to hide them. I started with trying to "hide" =#N/A and =NA()

Thank you for the help (again).

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.