I have an Excel file with 3 columns and about 500 rows of data. Column A contains state abbreviations (AK, AL, CA, NY, etc). A state abbreviation can appear once, many times or not at all. Column B contains dollar values. Column C contains dates.
I want a line chart that will display the dollar fluctuations over time for each of the states. How do I set it up? I haven't used Excel charts much, so I don't know what I'm doing. I tried inserting various versions of line charts but none are resulting in any meaningful data, so I'm obviously setting them up wrong. I need the exact steps. Thanks.