Hi,
Data Below: Hopefully the title is not too confusing, but I'm trying to create a bar chart to show salary ranges and the actual salary showing up as a plot. However, when I build a chart it will keep adding as an additional column when I'd just like the actual salary to be plotted as "grade 6".
Data Below: Hopefully the title is not too confusing, but I'm trying to create a bar chart to show salary ranges and the actual salary showing up as a plot. However, when I build a chart it will keep adding as an additional column when I'd just like the actual salary to be plotted as "grade 6".
| Grade | Salary Range Low | Salary Range High | Actual Salary |
| G6 | 80,000 | 100,000 | 90,000 |
| G8 | 100,000 | 120,000 | 110,000 |
| G10 | 120,000 | 140,000 | 130,000 |
| G11 | 140,000 | 160,000 | 150,000 |
| G12 | 160,000 | 180,000 | 170,000 |
| G13 | 180,000 | 200,000 | 190,000 |
| G14 | 200,000 | 220,000 | 210,000 |
| G6 | 80,000 | 100,000 | 110,000 |
