Hi
I want to create a combination chart in excel using all the values below but when I do create it, it looks very messy. Any help will be greatly appreciated
I want to create a combination chart in excel using all the values below but when I do create it, it looks very messy. Any help will be greatly appreciated
Year | Ethnicity | Cost | Activity |
2019/20 | White - British | £23,000 | 30 |
2020/21 | White - British | £24,000 | 40 |
2021/22 | White - British | £25,000 | 50 |
2022/23 | White - British | £26,000 | 60 |
2023/24 | White - British | £27,000 | 70 |
2019/20 | Black - Caribbean | £35,000 | 60 |
2020/21 | Black - Caribbean | £36,000 | 70 |
2021/22 | Black - Caribbean | £37,000 | 80 |
2022/23 | Black - Caribbean | £70,000 | 90 |
2023/24 | Black - Caribbean | £71,000 | 95 |
2019/20 | Asian - Pakistan | £63,000 | 100 |
2020/21 | Asian - Pakistan | £64,000 | 101 |
2021/22 | Asian - Pakistan | £65,000 | 103 |
2022/23 | Asian - Pakistan | £66,000 | 150 |
2023/24 | Asian - Pakistan | £67,000 | 170 |
2019/20 | Asian - Indian | £71,000 | 234 |
2020/21 | Asian - Indian | £72,000 | 260 |
2021/22 | Asian - Indian | £73,000 | 252 |
2022/23 | Asian - Indian | £81,000 | 234 |
2023/24 | Asian - Indian | £82,900 | 222 |
2019/20 | Others | £150,000 | 400 |
2020/21 | Others | £151,000 | 450 |
2021/22 | Others | £153,000 | 460 |
2022/23 | Others | £154,000 | 470 |
2023/24 | Others | £155,000 | 480 |
2019/20 | Asian - Bangladesh | £89,000 | 360 |
2020/21 | Asian - Bangladesh | £90,000 | 350 |
2021/22 | Asian - Bangladesh | £95,000 | 459 |
2022/23 | Asian - Bangladesh | £96,000 | 540 |
2023/24 | Asian - Bangladesh | £100,000 | 548 |