This is probably a very basic Excel question, but I just can't find the answer anywhere! If I type a word into cell A1 and make column A very narrow, the text overlaps into cell B1 (which is what I want). Now if I add a number to cell A2, it does not overlap into cell B2 but shows up as ###. What is the difference in the formatting of these two cells? Thanks!
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.