How to Stack Excel 2007 Charts for Better Analytical Results

Do your charts provide a clear understanding of what is really going on in your business? If not, you may be charting too much data. Charts that include too much data are not only hard to read, but also prevent you from getting your message across. Most audiences can remember only a few key points at a time. To make your charts easier to read, start with the conclusion you want your audience to infer from the chart; then chart only the supporting details. For example, this Excel 2007

Read More >>

Why does the value I entered appear with two decimal places?

Read More >>

Converting form data from MS word to MS excel for bulk responses

Hi! I have form data in MS word 2010 format with activeX controls and with macros enabled. It is response to a questionnaire, so it has all sorts of checkboxes, radio buttons, text boxes, date entries in activeX controls( and not legacy form controls). I want to be able to fill in cells in excel spreadsheet with inputs from the form fields. When I enable "Save form data as delimited text file" and try to save it as text file, the data doesn't get populated into the text file and just an empty text file gets created. Importing such a text file into excel won't then serve my purpose. Please help. Also, I have a massive number of such form documents, data from which I want to get populated into my excel  spreadsheet. I would therefore wish to automate the whole process of importing data and populating cells with it.   Thanks..

Read More >>