Graph.xlsx

<div>
It sounds to me as though a pivot chart would work with the original layout but a sample workbook would help.
</div>


It sounds to me as though a pivot chart would work with the original layout but a sample workbook would help.

<div>
<div class="content wysiwyg-content">
I have an Excel file with 3 columns and about 500 rows of data. &nbsp;Column A contains state abbreviations (AK, AL, CA, NY, etc). &nbsp;A state abbreviation can appear once, many times or not at all. &nbsp;Column B &nbsp;contains dollar values. &nbsp; Column C contains dates.<br />
<br />
I want a line chart that will display the dollar fluctuations over time for each of the states. &nbsp;How do I set it up? &nbsp;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. &nbsp;Thanks.
</div>
</div>


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.

Excel line chart

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.