# 9.1.17 十大客戶分析圖

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-L_FtlhGp15q42bGA6KK%2F-L_Fu_d_7pXz78ncCnbt%2FA16-%E5%8D%81%E5%A4%A7%E5%AE%A2%E6%88%B6%E5%88%86%E6%9E%90%E5%9C%96.png?alt=media\&token=9bd315f6-b8f5-4cd6-afa2-4502bb181534)

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-L_FtlhGp15q42bGA6KK%2F-L_FuidwnBO4kv_GUSVJ%2FA16-001.png?alt=media\&token=aac9e1f6-fbb2-457e-bdef-bfff558a3090)

圖表可利用【金額】、【數量】或【毛利】來排名十大VIP客戶

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-L_FtlhGp15q42bGA6KK%2F-L_Fv1EY45GLm49kBfvB%2FA16-002.png?alt=media\&token=49f5a9e2-99ab-45a3-8c62-89bd3f4e6364)

【轉出】excel資料的內容：

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-L_FtlhGp15q42bGA6KK%2F-L_FvIanFw0O3zD_dw34%2FA16-003.png?alt=media\&token=954f4872-a1ec-4af9-accb-d259df24aa1e)