Overview
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.
Tags
Share
Reviews Add a review
No reviews yet

More From Tim Vipond

Browse our top rated business templates. See All
Series A Preferred Share Analysis
950
223
The template analysis the return profile a Series A Preferred Shares Investment. The comprehensive analysis evaluates the impact of a…
Independent contractor agreement template Independent Contractor Agreement Template
622
182
Download this free Independent Contractor Agreement Template.
Board Meeting Minutes Example Template Board Meeting Minutes Template #2
735
160
Download Board Meeting Minutes Template #2
Detailed Income Statement Template Detailed Income Statement Template
1,113
303
This Detailed Income Statement Template was created for a Landscaping Irrigation Lighting Company, but can easily be adapted to a…
DCF Model and Free Cash Flow Valuation Template
568
107
This detailed DCF Model and Free Cash Flow Valuation Excel Template, will use the forecasted FCFF to calculate the value…
Customer Lifetime Value (LTV) Analysis Customer Lifetime Value (LTV) Analysis Template
980
261
This Lifetime Value (LTV) Template is a great tool to calculate the Present Value of the LTV of a customer.…