This Gold Charts Dashboard Template will help you visualize some of the key metrics for a Gold ETF and how it compares to the commodity. The data tab is where you would import the daily required data, these include the following:
  • Gold Price
  • Total Ounces
  • Change in Ounces
  • Last Price of ETF
  • Volume
The other tab contains the dashboard, where all the graphs are presented. The data is displayed in 4 clean graphs that are designed to help you track and compare the movements of the ETF to the commodity's price movement. The first graph is a combo of an area and line chart where you can contrast the total ounces to the gold price per ounce. The second chart is a column chart that shows the change in ounces in multiple periods. The third chart is a scatterplot with a line of best fit, this graph aims to show the correlation between the number of gold ounces held by the ETF and the Gold Price. The last chart is also a combo of a column chart and a line chart, which contrasts the daily change in ounces with the gold price. Here is a quick summary of the 4 charts:
  1. Total Ounces vs Gold Price per Ounce - Combo Chart (Area + Line Chart) 
  2. Daily Change in Ounces - Column Chart
  3. Gold ounces vs Gold Price - Scatterplot
  4. Daily Change in Ounces vs Gold Price - Combo Chart (Column + Line)
Dashboards are extremely useful tools for data visualization. They help business professionals track and monitor the changes in key metrics over time. If you are a beginner with Dashboards the following template is a great starting point: How to create a dashboard in Excel. If you want to learn more about Dashboard, check out this resource in the Corporate Finance Institute website: Creating a Dashboard in Excel Thank you for downloading this FREE Gold Charts Dashboard Template.
Reviews Add a review
No reviews yet

More From Tim Vipond

Browse our top rated business templates. See All
Marketing Deck Marketing Proposal Template
This marketing proposal template is a great starting point for marketing professionals who need to submit a marketing project. It…
Series A Preferred Share Analysis
The template analysis the return profile a Series A Preferred Shares Investment. The comprehensive analysis evaluates the impact of a…
Meeting Schedule Framework
This meeting schedule template slide can be used to organize and structure your team meetings at your company.
Independent contractor agreement template Independent Contractor Agreement Template
Download this free Independent Contractor Agreement Template.
Board Meeting Minutes Example Template Board Meeting Minutes Template #2
Download Board Meeting Minutes Template #2
Detailed Income Statement Template Detailed Income Statement Template
This Detailed Income Statement Template was created for a Landscaping Irrigation Lighting Company, but can easily be adapted to a…
See All