For a dashboard that aims to tell a story about sales and the sales customer ratio, a column chart is an effective choice. Column charts are particularly useful for showing data changes over a period of time or for illustrating comparisons among items. In this case, a column chart can clearly display the sales figures for each site, allowing for easy comparison across different sites. Additionally, it can be used to represent the sales customer ratio by showing the proportion of sales per customer, which can provide insights into customer behavior and sales effectiveness.
* Line charts are best suited for displaying data trends over time, rather than for comparing individual categories.
* Pie charts could show the proportion of sales for each site, but they are not as effective as column charts for comparing multiple categories.
* Scatter charts are used to show the relationship between two variables, which is not the focus in this scenario.
References:
* Effective Use of Column Charts1
* Choosing the Right Chart for Your Data2
* Sales Dashboards: Examples & Templates3