tbrynard01
Board Regular
- Joined
- Sep 20, 2017
- Messages
- 129
- Office Version
- 365
- Platform
- Windows
I was able to create a combination chart a few years ago but need to add a column which should also be a stackable column but not figuring out how to do that - I'm missing some data but will add that. I want to stack Operating and grant expenses
This was from the old chart before I added the new columns
Also curious how i can get the legend to sort in the same order as the columns
Contributed | Investment | Operating Expenses | Grant Expenses | Net Assets | |
2011 | $ 499,130 | $ 195,276 | $ 2,223,322 | ||
2012 | $ 332,453 | $ 284,094 | $ 3,031,856 | ||
2013 | $ 613,810 | $ 105,449 | $ 3,109,798 | ||
2014 | $ 346,693 | $ 300,014 | $ 3,179,472 | ||
2015 | $ 386,459 | $ 317,084 | $ 3,211,445 | ||
2016 | $ 402,085 | $ 324,521 | $ 3,052,588 | ||
2017 | $ 580,609 | $ 151,924 | $ 315,431 | $ 154,869 | $ 3,523,776 |
2018 | $ 358,489 | $ 124,440 | $ 315,696 | $ 276,290 | $ 3,189,552 |
2019 | $ 592,075 | $ 117,095 | $ 3,996,186 | ||
2020 | $ 449,334 | $ 144,078 | $ 3,967,127 | ||
2021 | $ 949,906 | $ 719,015 | $ 5,243,235 | ||
2022 | $ 561,014 | $ (686,899) | $ 3,946,102 | ||
2023 | $ 726,849 | $ 607,339 | $ 4,818,551 |
Also curious how i can get the legend to sort in the same order as the columns