I am working on a collegiate level project. I would like find an ArcGIS product where I could map out my memberships (3k members) for a company named Deep Blue Sail. I have three membership plans, (Prime, Plus, Standard) where I collected revenue from 2012-present in a static excel file.
1. I would like to click in a particular state and have it display my revenue and expenses for 2017. I already have a static excel spreadsheet for this, however all my locational data is in lat/log.
2. Then if I clicked on a state not only would show my the state details of revenue/expenses, but then I could drill down to the county level and see my revenue and expense by different levels of color gradients. Again all of my locational data is in lat/long, so I'm sure I'll have to convert them to county FIPS codes. If there's a conversion program in ArcGIS, please provide a link.
3. Lastly, I would like to see a line graph next to the map and I want my data to simultaneously display results and have them linked. In other words, when I press on a state level such as California it would give me info as described in the first two paragraphs, and it would also include my yearly sales since 2009 to present on a line graph next to the map. I need to understand the historical context of my California revenues and expenses.