The numbers that I'm doing the histogram on is information that is transfered (formula eg =Data!C2) from another sheet (data). That's why I've got the problem.
When I do a histogram on the data sheet I don't have the problem.
Comparing the two results, not only do I have More in the results, some of the totals are incorrect.
Is there anything I can do to the formula eg =Data!C2 so that the histogram works properly.