We cover how to graph active exposures of a fund in Excel and manipulate the axes. In our example, we have the active exposures i.e. the extent to which the fund’s exposure differs from that of the benchmark. What we want to do is illustrate this data in a graph in an appealing way. We cover how to do this showing both the active exposures on the horizontal and vertical axis.
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/fK13LdAIrQw
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
Create Column Chart: (0:36)
Create Bar Chart: (1:54)