I have been tasked with displaying the results of our upcoming municipal elections (8-28) as they come in. We are still operating in shapefiles and file / personal geodatabases. My plan is to use an ArcMap layout to display the precincts as reported or not, with some type of tabular data for the results.
I have no problems displaying the spatial component of this project. The tabular data is the problem. I want to display each candidate name, the votes by precinct, totals by candidate, and percentage by candidate. I tried creating an excel spreadsheet in the layout of the map by inserting a new object and choosing MS excel workbook. I then created a excel spreadsheet and that worked somewhat. The spereadsheet looked great until I closed the mxd and opened this morning. Today the spreadhseet had lines cutting through the text and my totals and percentages are displayed out of where they should be. I tried to delete the spreadsheets and recreate and got the same results.
Does anyone have any tips, trick, or another method that works to accomplish this task?