Automatically translated.View original post

📊 Tick the battle. Full circle!

📊, tick the box. Full circle!

Turn a Plain To-do List into an Automatic Update Circle Chart in Excel ✅

Complete the task immediately. Fill in and see% progress in real time!

💡 No need to load more programs. Use Excel you have.

Want to be good at Excel like this again?

Click Follow now 👉 @ Excel Data Master

# Exceltutorial # exceltips # Excel # Trending # Lemon 8 Howtoo

2025/8/15 Edited to

... Read moreถ้าคุณอยากทำ “วงกลมเปอร์เซ็นต์” ไว้เช็กความคืบหน้าจาก To-do List ใน Excel แบบกรอกแล้วกราฟอัปเดตทันที ทำได้ง่ายมากค่ะ/ครับ (เหมาะกับคนทำงานเป็นตารางรายวัน เช่น จันทร์-ศุกร์ หรือทำตาม KPI) 1) เตรียมตาราง To-do List - สร้างคอลัมน์: งาน | สถานะ - ในคอลัมน์ “สถานะ” แนะนำให้ทำเป็นดรอปดาวน์เลือกได้ เช่น “เสร็จ”, “ยังไม่เสร็จ” (Data Validation > List) - หรือถ้าชอบติ๊กเป็น 0/1 ก็ทำได้: 1 = เสร็จ, 0 = ยังไม่เสร็จ 2) สรุปจำนวนงานเสร็จ/คงเหลือ (เพื่อป้อนให้กราฟ) ตัวอย่างใช้คำว่า “เสร็จ/ยังไม่เสร็จ” - งานที่เสร็จ: =COUNTIF(B2:B100,"เสร็จ") - งานทั้งหมด: =COUNTA(A2:A100) - งานคงเหลือ: =งานทั้งหมด-งานที่เสร็จ ถ้าใช้ 0/1 (1=เสร็จ) - งานที่เสร็จ: =SUM(B2:B100) - งานทั้งหมด: =COUNTA(A2:A100) - งานคงเหลือ: =งานทั้งหมด-งานที่เสร็จ 3) ทำกราฟวงกลมใน Excel - เลือกเซลล์สรุป 2 ค่า: “เสร็จ” และ “คงเหลือ” - Insert > Pie Chart (หรือ Doughnut จะสวยและอ่านง่ายกว่า) - ตั้งค่าสีให้ชัด: “เสร็จ” สีเข้ม, “คงเหลือ” สีอ่อน 4) ใส่เปอร์เซ็นต์บนวงกลม - คลิกกราฟ > Add Data Labels - Format Data Labels > ติ๊ก “Percentage” (และจะซ่อน Value ก็ได้) 5) อยากให้เหมือน “สัญลักษณ์วงกลม” แสดงความคืบหน้า ถ้าใช้ Doughnut Chart: ปรับ Hole Size ประมาณ 70–80% แล้วใส่ข้อความ % ตรงกลางด้วย Text Box ที่ลิงก์กับเซลล์เปอร์เซ็นต์ (เช่น =งานที่เสร็จ/งานทั้งหมด) ทริคที่ช่วยให้ใช้งานจริงมากขึ้น - แยกตามวันได้ เช่น “วันจันทร์: กำหนด KPI / ประชุมทีม / ออกแบบกราฟิก” แล้วทำสรุปเป็นรายวันหรือรายสัปดาห์ - ถ้างานยังไม่ใส่สถานะ อยากไม่นับ ให้ใช้ COUNTA ที่คอลัมน์งานเป็นตัวกำหนด “งานทั้งหมด” จะตรงกว่า - ตั้งชื่อช่วงข้อมูล (Named Range) เพื่อขยายรายการงานแล้วกราฟตามอัตโนมัติ หรือทำเป็น Table (Ctrl+T) จะสะดวกสุด ทำครบชุดนี้ คุณจะได้ทั้งกราฟวงกลมใน Excel และวงกลมเปอร์เซ็นต์ที่อัปเดตตาม To-do List แบบเรียลไทม์ ใช้โชว์ความคืบหน้ารายงานงาน/โปรเจกต์ได้เลย

Related posts

Four women showcase 'A Baddie everyday wear' in various casual outfits. Styles include a corset with wide-leg jeans, a cropped jacket with a maxi skirt, a denim jacket with a long skirt, and an oversized striped shirt with jeans.
Four women model casual 'baddie' looks. Outfits feature a denim jacket with black leggings, a beige sweatsuit, a green 'NEW YORK' sweatshirt with beige pants, and a geometric print tee with black leggings.
Four women display diverse casual styles. Looks include a red bucket hat with a sweatshirt and jeans, a puffer vest with distressed jeans, a puffer jacket with dark pants, and a graphic t-shirt with a red cap.
Fashion’s full circle: BADDIE EVERYDAY WEAR
#fashioninspo #baddie #fyp #lemon #lemoncreator
ANGELFACE

ANGELFACE

1353 likes

50 minutes. Full body. Magic circle.
Our balance was challenged and we loved every second. 🔥 (video is sped up) #matpilates #magiccirclepilates #pilatescommunity
Glowing Knightly

Glowing Knightly

91 likes

Getting close to a full circle
#honda #250sx #3wheelers #lemon8 #driftingaway
Jed Bleecker

Jed Bleecker

100 likes

💛 The Full Circle
There’s a reason for these curves — they began in heartache, but they were shaped by grace. I prayed through loss, and somewhere between the tears and the faith, God sent me my little miracle. 🌈 Some say he was made with the whole rainbow — and I believe them. Because when two rainbow b
thatanthrogirl

thatanthrogirl

5 likes

Full Circle Moments 🥹❤️
From 1st grade to now — moments like this hit different. Watching your childhood best friend step into her new chapter at the most beautiful Sikh wedding felt so full-circle. The colors, the traditions, the energy… everything was magic. ✨ #indianwedding #sikhwedding #childhoodbestfriend
Sarina Agarwal

Sarina Agarwal

111 likes

Emotional Full Circle ending.
After six Seasons with a long wait between them The Handmaids Tale has came to an end. The Finale wasn’t what we fans expected but wasn’t disappointing either! It was a slow episode but full of emotions, cry worthy scenes, heart warming, and storylines wrapped up while leaving it open for the
TheAbbottWay

TheAbbottWay

6 likes

Full circle 🫶🏼
#teachers #teacherlife #teacher #teachersoflemon8 #dreamjob
Morgan Jewell

Morgan Jewell

108 likes

full circle moment 🥹🫶
2025 was the hardest year of my life, BUT i did it 🥹 me from a year ago would be SO proud. i literally used to cry, journal and pray for the life i have today 💜 #dvawareness
chelly jae

chelly jae

6 likes

A full circle moment 🥹🤍
#wedding #weddingdress #weddingday
Caitlin Eliza

Caitlin Eliza

54 likes

A black and white portrait of an older man, likely Albert Fish, wearing a suit and tie. Overlays include "Pt.4," "Season Of The Taurus," and "ZODIAC KILLERS," along with "Lemon8" and "@coffeestain3d" branding.
𝕊𝕖𝕒𝕤𝕠𝕟 𝕠𝕗 𝕥𝕙𝕖 𝕋𝕒𝕦𝕣𝕦𝕤: Full Circle
First let me start this post off with my apologies. I had intended to finish this edition of Zodiac Killers off with Taurus season however, life happens. So, let’s get into it and finally end this monstrous story. Albert Fish Part 4: Billy Gaffney : Age 4 (Abridged) Confession letter of Albe
Coffee Stained

Coffee Stained

3 likes

Muhammad Ali, wearing a light shirt, shakes hands with a police officer in uniform. They are in a room with bookshelves, poinsettias, and a wreath, suggesting a holiday setting. A framed picture of Ali is visible on a shelf.
The Strange Full Circle Moment When I Finally Ali
My life intertwined with Muhammad Ali’s decades before I met him. Full story on Real Police Talk TikTok. #MuhammadAli #JoeFrazier #PoliceStories # YouTrulySeeItAll
RealPoliceTalk /TikTok/YouTube

RealPoliceTalk /TikTok/YouTube

0 likes

Full circle moment for Logan as a mom 🥲❤️
Logan use to run down this same hallway with her mom and now it’s full circle doing it with Tayelynne. I wish all 3 of them could be running down it together, but we know she’s watching over us smiling ❤️🥲 Did anyone catch our little TJ? 🖤 #andyandlogan #relationships #couples #momlife
❤️Andy & Logan❤️

❤️Andy & Logan❤️

119 likes

PR unboxing + Full circle moments🤍
I cannot waitttt to try out this new griddle WeSponsored sent me 🩷 but let’s get into Javvy really quick 🫠 Manifesting works, y’all. ☕✨ I’ve been dying to try Javvy for over a year, trying to get into my at home barista era again 🙂‍↔️ but life kept getting in the way. Then out of nowhere, they e
Des♡| Lifestyle + Selcare🌷

Des♡| Lifestyle + Selcare🌷

13 likes

really just full circle
#fyp #fypシ
laken🤎

laken🤎

15 likes

We come full circle
I had a strange period in my life where I had lost myself; my identity, even though it was so strong before. I’ve come full circle back to who I used to be, and it feels great. ❤️ #poetry #mentalhealth #addiction #recovery #love #loss #bipolar
Hannah Winters Poetry

Hannah Winters Poetry

1 like

A collage featuring a fashion designer modeling her creations, including a black satin top with silver pants, an orange dress on a runway, and a leopard print outfit. It includes inspirational quotes like 'I am enough, just as I am' and 'I don't design clothes. I design dreams. -Ralph Lauren'.
A collage showing a fashion designer at various events, including speaking with a microphone, attending social gatherings, and posing with groups of people in diverse outfits, highlighting her engagement and presence in the fashion community.
A collage featuring a fashion designer and models showcasing designs on a red carpet at an event with 'Hampton SECCA' branding. It also includes a woman in a green floral dress and a designer working with a mannequin, reflecting design and event participation.
Fashion’s full circle: when passion collides
#Lemon8Scrapbook #passionfashion #fashionwithadifference #futurefashiondesigner #embracevulnerability #lemon8fashion #Lemon8Diary #whatsinmycloset Here’s a simple content plan for a girl in fashion ✨️1. 💖Behind-the-Scenes (BTS) Content💖 - **Weekly Studio Tours:** Share short vi
Skinflint _

Skinflint _

9 likes

Our photograph only sunnies at FullCircle Florals!
What a ride it’s been getting these cuties up and blooming! A photog friend captured this shot of me in them the other day and I love it! LRuiz Photography nailed it! 📍 City/Country: Vina, CA.USA #fullcircleflorals #flowers #sunflowers
FullCircle Florals

FullCircle Florals

2 likes

full circle moment in the 731 🥲
Jackson #hometown #jacksontn #smalltown #vlog #countrymusic
Bella Lam

Bella Lam

2 likes

Wicked ✨ full circle moment with family 💚🩷
this was a magical moment for us! 10/10 recommend seeing the movie 🎬 💚 #wicked2024🖤💚🎀✨ #wicked #familytime #specialmoments #memories
Allegra 🌻

Allegra 🌻

8 likes

A close-up of a wrist adorned with two permanent jewelry bracelets, one silver and one gold, from Full Circle Rva in Midlo VA. The gold bracelet is identified as 'Wildest Dreams' style, with a price of $45 each.
Full Circle Permanent Jewelry ✨🤍
First timer! 😇 Lady was nice and sweet! 😊 Studio space was clean and welcoming. 💵 Price: $45/varies on particular style Time: Took 10 minutes max Style: Wildest Dreams ⭐️Overall rating: 10/10 I will be going back to get a necklace 🥰 Recommend booking an appt! Although walk ins
B R E E ZY

B R E E ZY

0 likes

Come see Lainey at Full Circle Bookstore
August 2nd starting at 3pm, Lainey Ross will be at Full Circle Bookstore signing her small town romance books set in Oklahoma! Tornado Ally and Hayley’s Hayfield has opposites attract, strangers to lovers, tornadoes, closed door romance, and more. Stop in and say hello!🤍 #closeddoorromance #
Author Lainey Ross

Author Lainey Ross

3 likes

FULL CIRCLE MOMENT
I pulled this old thing out the other day to watch it with my daughters before I took them to see the new movie… I never thought I’d be watching this same movie with my own kids🥹💕 I used to use these vhs tapes to build houses for my toys and watched this all the time. so nostalgic🌊☀️ I lov
Theresa

Theresa

27 likes

✨ From Winner to Judge: A Full-Circle Moment ✨
Last season, I walked away as the winner of Fashion Competition Season 1. Now, I’m returning—not as a contestant, but as a JUDGE for Season 2! It feels surreal to be on the other side of the runway, guiding the next generation of designers as they push boundaries and showcase their creativity.
Skinflint _

Skinflint _

4 likes

Come see author Lainey Ross at Full Circle
You’re invited to Full Circle Bookstore in OKC, OK on August 2nd at 3pm for a signing with author Lainey Ross! Lainey writes closed door, small town romances with twisters! 🌪️ Her debut, Tornado Ally, is about two strangers that get trapped in a shelter together. Her most recent release,
Author Lainey Ross

Author Lainey Ross

4 likes

Full Circle Moment
📍 Madisonville/ TN Amanda and I have been to many wineries in North Carolina and Tennessee. One particular winery we love is Tsali Notch Vineyard as a matter of fact we announced expecting Tallulah while we were at this winery. Now a full circle moment we brought Ms. Tally to the same wine
Daddydearrest

Daddydearrest

26 likes

A laptop on a black and white spotted rug, with a plant, displaying text 'TARGET DEALS ITEMS UNDER $3.00', indicating a post about discounted items.
A tube of toothpaste is displayed, showing a final price of $0.99 after a coupon is applied, originally priced at $2.99.
A bottle of sunscreen is displayed, showing a final price of $0.49 after a coupon is applied, originally priced at $1.99.
Target Circle Deals/Coupons - Items Under $3
Sharing eight Target Circle coupons that will bring each item’s cost to under $3! You can get these deals on Target’s app. Plus, if you register as a college student you will get a one time use 20% off coupon! I’m always checking the Target Circle app because they have amazing deals like these e
Kendra

Kendra

18 likes

A Returning Client’s Full Circle Journey
Some clients stay with you through seasons of life—this one truly embodies that. She first came to CC for her brows over three years ago. Time passed, her previous embroidery had gently faded, and she gracefully transitioned into motherhood. Once ready, she returned, trusting CC once again to re
Dr.Cic🤎Brow Art

Dr.Cic🤎Brow Art

1 like

Talk about a full circle moment.
#gettoknowme #weddingplanner #weddingcoordinator #blissweddingplanners
🪬 𝑇𝑜𝑚𝑚𝑖𝑒 🩷

🪬 𝑇𝑜𝑚𝑚𝑖𝑒 🩷

2 likes

See more