In article ,
says...
i am trying to create a histogram. everytime i put in the input range i get
an error saying input range must be a contiguous reference. also i am trying
to go from one sheet to another which it keeps telling me that that name is
not valid. anyone got some ideas

Well, the input range must be a single contiguous range. It's a requirement
for this tool.

I am not sure what "trying to go from one sheet to another" means. Does it
mean the histogram (i.e., the result of the tool) is to be on another sheet?
If so, select the 'Output Range' option, then click the cell in the other
sheet where you want the results.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions