Try   HackMD

Excel選擇一個適合的圖表

LHB阿好伯, 2021/05/01

tags: Excel 可視化

今天在網路上發現Dr. Abela展示的Choosing a good chart
這張圖非常好的呈現了幾種常用的資料圖表

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

我簡單的嘗試以Excel呈現他上面的圖表
測試過後在比較的多變量鑲嵌圖表Excel無法繪製
其餘的都能呈現出來

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

圖片可能看不清楚可以到Coggle中觀看

最後附上範例檔案有興趣的可以下載看看

檔案在此
Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

下次再來嘗試用ggplot2繪製

🌟全文可以至下方連結觀看或是補充
https://hackmd.io/@LHB-0222/Excel-Choosing_a_good_chart

全文分享至

https://www.facebook.com/LHB0222/

https://www.instagram.com/ahb0222/

有疑問想討論的都歡迎於下方留言

喜歡的幫我分享給所有的朋友 \o/

有所錯誤歡迎指教

全部文章列表

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →