Try   HackMD

柱狀圖標示數據百分比_使用Excel & ggplot2繪製

LHB阿好伯, 2021/04/17

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 可視化 R ggplot2

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.dcard.tw/f/talk/p/235759042

用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 →

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 →

插入組合圖

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 →

將散佈圖標記隱藏起來

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 →

Excel檔案下載

Excel 方法2

這邊在介紹一個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 →

R_ggplot2繪製



















library(readr)
library(ggplot2)
library(ggeasy)
library(ggsci)
library(extrafont)


DcardData <- read_csv("D:/Dcard.csv")
p <- ggplot(DcardData,aes(x = 選項, y = 次數)) +
  geom_bar(stat="identity")  
p  +  theme_bw() +  #更改主題
  theme(text=element_text(family = "Times New Roman")) + #修改字體
  easy_x_axis_title_size(16) + #更改XY軸字體大小
  easy_y_axis_title_size(16) + 
  easy_x_axis_labels_size(14) + 
  easy_y_axis_labels_size(14) +
  geom_text(aes(label = 次數), vjust=-0.1, color=1, size=8) + 
  geom_text(aes(label = paste(round(次數/sum(次數)*100,1),"%")), vjust = 1.2, color = "white", size = 8)

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://hackmd.io/@LHB-0222/Excel_barplot

全文分享至

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

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

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

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

有所錯誤歡迎指教

相關文章

ggplot2推薦圖形配置
ggplot2入門筆記-1

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
7279

Read more

Pico W 驅動 TFT 顯示屏：使用 micropython-ili9341 顯示 RAW RGB565 圖片

import timefrom machine import Pin, SPIfrom ili9341 import Display, color565 # 確保 ili9341.py 和 main.py 在同一個目錄下

Jul 24, 2025
Proxmox VE 使用 SMB/CIFS 實現輕量級遠端備份全攻略

好的，這是一個炎熱的週五下午，在左營這裡很適合來杯冷飲，靜下心為這趟技術旅程做個完美的總結。

Jul 22, 2025
在 Proxmox VE (PVE) 的 LXC 容器 (CT) 中安裝 Tailscale 指南

本文件旨在說明如何在 Proxmox VE 環境下的 Linux 容器 (LXC/CT) 中成功安裝並執行 Tailscale。與在實體機或虛擬機 (VM) 中安裝相比，容器環境最關鍵的差異在於需要從 PVE 宿主機為容器啟用 TUN 設備。

Jul 9, 2025
R語言常用好用套件紀錄

hackmd-github-sync-badge

May 19, 2025
Read more from 阿好伯
Published on HackMD