Try   HackMD

EXCEL斷裂柱狀圖繪製與美化

LHB阿好伯, 2020/10/02

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 →

tags: 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 →

問題

昨天遇到一個好朋友他妹妹的同學在問說下圖怎麼畫

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 →

若是在例如我常用的Sigmaplot等專業繪圖軟體內建相對應的功能
而在使用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 →

美化

修改數列設定與樣式

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 →

一般遇到需要列印成黑白圖片的情況下
原先柱狀圖的顏色在區分資料類別上會有困難
這時候就可以修改其填充樣式

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 →

複製出一個相同的圖片之後會用到

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 →

這邊我會建議刪除格線這樣觀看圖片時整體畫面比較乾淨

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 →

斷裂長條圖的重點在於更改兩張圖片的Y軸範圍最大最小值
使得兩張圖表有區隔將原先較小的數值放大

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 →

去除框線後將兩張圖上下堆疊

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 →

再來可以用PPT繪製Y軸的斷裂符號

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 →

遮蔽中間多餘的圖案

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 →

那就完成今天的圖片繪製

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 →

全文分享至

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

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

喜歡的幫我分享給所有的朋友 \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 →
全部文章列表

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 →

Last changed by 
 
阿好伯
分享自身所學到的一些東西 規劃主題應為6大類 1.Excel 2.統計軟體_R_SPSS 3.其他軟體使用心得 4.專業知識紀錄 5.好書分享 6.生活記事 希望有人喜歡，也幫助到更多人
0
7317

Read more

一圖勝千表_數據可視化_基本圖表篇

[color=#40f1ef][name=LHB阿好伯, Jan 26, 2019 10:05 PM]:earth_africa:

Apr 7, 2025
Raspberry Pi網路攝像機_實物投影機

[color=#40f1ef][name=LHB阿好伯, 2021/07/16]:earth_africa:

Mar 11, 2025
R語言常用好用套件紀錄

hackmd-github-sync-badge

Jan 25, 2025
Ntfy介紹_自行架設及使用說明

[color=#40f1ef][name=LHB阿好伯, 2024/10/22]:earth_africa:

Jan 23, 2025
Read more from 阿好伯
Published on HackMD