Excel Charts in a Dashboard Report

Screenshots of the Dashboard

Features in the Excel Dashboard

1. The dashboard contains a dropdown box that allow you to click and select the fund you wish to review.





2. A table that displays the profitability of the fund for the last 2 years. The table will show a green arrow if the variance make a positive contribution to profit for this year comapred to last year.






3. The chart on the fund ranking are automatically arranged in descending order and the chart will highlight the bar representing the selected fund in red. In case the bar is too short, the top left hand corner of the chart will display the rank and the rate of return (profit only) of the fund.





4. The second chart will display the income and profit trend of the selected fund for the last 5 years. The y axis will auomatically switched in denomination from thousands to millions when the values in the chart cross the half a million mark.





5. Finally, you can easily add more funds for comparison just by filling in the details in the next empty column all the way to column Z.

If you wish to see this Unit Trust Dashboard in action, complete the form below and have it send your inbox Now!

Unit Trust Dashboard Report Your Name: Your E-Mail: How did you find us?: Remember: Your privacy is safe and you may stop further mailings at any time. PS: We need you to click on the link in our confirmation email to confirm your name and email address so we can verify you are a real person. Please look out for it.