Understanding Line Charts
I am trying to create a chart that looks like the image below. I want to show the average yearly salary increase per department by year. This is currently in a database of personnel records. Compensation(including compensation year & increase amount) and position(including department) are both on separate tables, and both are related to the personnel records table, but not to each other.
I have very little understanding about quick charts in general, but even less about how line charts are made. Can anyone explain to me? What would need to be done in order to accomplish my goal?