Automatically translated.View original post

Chart in EXCEL

3/4 Edited to

... Read moreจากประสบการณ์ส่วนตัวที่ได้ใช้ Excel มาช่วยในการทำรายงานหรือการบ้าน ผมพบว่าการทำกราฟใน Excel ไม่ใช่เรื่องยากเลย โดยเฉพาะเมื่อเข้าใจพื้นฐานของกราฟแต่ละประเภท เช่น กราฟแท่ง (Column Chart) ที่เหมาะสำหรับเปรียบเทียบข้อมูลระหว่างช่วงเวลา หรือกราฟเส้น (Line Chart) ที่ช่วยแสดงแนวโน้มของข้อมูลในระยะยาว และกราฟวงกลม (Pie Chart) ที่เหมาะกับการแสดงสัดส่วนของข้อมูลในแต่ละส่วน ขั้นตอนง่ายๆ ในการสร้างกราฟ คือ 1) เตรียมข้อมูลในตารางให้ชัดเจน 2) เลือกข้อมูลที่ต้องการใช้ทำกราฟ 3) กดทางลัด Alt + F1 เพื่อสร้างกราฟแท่งพื้นฐานในแผ่นงานเดียวกันทันที หรือไปที่เมนูแทรกแล้วเลือกประเภทกราฟตามต้องการ และ 4) ปรับแต่งกราฟ เช่น ตั้งชื่อกราฟ ชื่อแกน เลือกสไตล์ หรือเพิ่มป้ายกำกับให้ข้อมูลดูเข้าใจง่ายขึ้น สิ่งที่ทำให้ผมประทับใจคือหลังจากทำกราฟเสร็จ สามารถคลิกที่กราฟแล้วแก้ไขข้อมูลได้ทันที ทำให้ไม่ต้องสร้างกราฟใหม่เมื่อข้อมูลมีการเปลี่ยนแปลง นอกจากนี้ การใช้กราฟอย่างเหมาะสมก็ช่วยให้รายงานหรือการบ้านที่ทำดูเป็นมืออาชีพและน่าสนใจ ช่วยสื่อสารข้อมูลได้ชัดเจนและรวดเร็วขึ้น สำหรับใครที่เป็นมือใหม่ อยากแนะนำให้ลองฝึกทำกราฟตามขั้นตอนเหล่านี้ พร้อมลองเปลี่ยนรูปแบบกราฟใน Excel ดู จะช่วยให้คุ้นเคยและรู้ว่าแต่ละประเภทกราฟเหมาะกับข้อมูลแบบใด อย่าลืมเซฟงานของคุณไว้ด้วยนะครับ เผื่อเวลาต้องแก้ไขหรือใช้ซ้ำในครั้งถัดไป เป็นการเพิ่มประสิทธิภาพการทำงานและลดเวลาในการจัดเตรียมรายงานได้มากเลยทีเดียว

Related posts

4 easy steps to make progress chart in Google Shee
4 easy steps to make progress chart in Google Sheets #googlesheets #googlesheetstutorial #exceltips #digitalplanner #googlesheetstips #excel
Lemon Goods

Lemon Goods

625 likes

A comprehensive braiding chart map displaying various braid sizes: extra small, medium, smedium, large, and jumbo. Each section features a head diagram indicating approximate braid counts and real-life examples of the corresponding braid style on a person, showcasing the parting and finished look.
Braiding Chart Map🥰
#good stitching #braidhairstyles #braidsinspo #braidstyle #braidout
mrsshinn97

mrsshinn97

6027 likes

Excel shortcuts every student should know! 👩🏻‍💻
Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live
emilie.studygram

emilie.studygram

1175 likes

Excel org chart
Tab your way to an org chart in excel #exceltricks #tutorial #exceltutorial #excel #exceltraining #fyp #spreadsheet
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

32 likes

100 Excel Tips
100 Excel Tips The best Shortcuts, Formulas, Formatting & Advanced Tips Bookmark this, you'll save 1,000 of hours! A list of tips that all professionals need. Here is a preview: ⌨️ Shortcuts 1. How to hide a column? Ctrl + 0 2. How to hide a row? Ctrl + 9 3. How to
ExpressoSolut

ExpressoSolut

1429 likes

Project timeline using excel
Project timeline how to using excel #projectmanagement #excel #exceltricks #exceltutorial #tutorials
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

11 likes

8 Free Online Certifications to Boost Your Resume
Hi, lemons! In today's competitive job market, having the right certifications can make a significant difference in showcasing your skills and expertise. Online certifications are not only convenient but also cost-effective. Here are six free online certifications that can give your resume a va
Lifestyle Babe

Lifestyle Babe

1214 likes

Excel cheat sheet
Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

14 likes

A laptop displays an Excel spreadsheet with charts and data, while a hand interacts with the trackpad. The image features text overlay "Excel shortcuts cheat sheet" and "SWIPE FOR MORE," indicating a guide to Excel shortcuts.
This image lists four essential Excel shortcuts: Autosize Columns (Alt + H + O + I), AutoSum (Alt + =), Display formula in cells (Ctrl + ~), and Insert Current Date (Ctrl + ;). It is part of a multi-page guide.
This image presents four more Excel shortcuts: Insert Hyperlink (Ctrl + K), Freeze Rows & Columns (Alt + W + F + F + F), Fill Down / Fill Right (Ctrl + D and Ctrl + R), and Paste Special - Values (Alt + E, S, N).
Excel shortcuts every student should know! 👩🏻‍💻
Excel shortcuts can significantly improve your efficiency and productivity when working with spreadsheets. Here are some powerful Excel shortcuts that everyone should know. These shortcuts can save you a lot of time and make working with Excel more efficient. Practice using them regularly to become
teal.days

teal.days

2718 likes

100 Excel Shortcuts
#excelshortcuts #excelformulas #exceltips
LouiseAnn1960

LouiseAnn1960

744 likes

Excel time stamps
Yes, I said permanent time stamps #exceltips #excel #tutorial #worktips #exceltraining #exceltricks
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

53 likes

Save these Useful Excel Shortcuts!
Hey everyone! Excel shortcuts are super helpful for getting things done faster and smoother. They range from simple tricks for moving around your spreadsheet to more advanced ones for formatting and data manipulation. Mastering these shortcuts can really save you time and make you more efficient! I
Yun Jung

Yun Jung

295 likes

How To Actually Read Your Birthchart
Most people are reading the wrong sign… and that’s why astrology “doesn’t hit” for them. If you’re only checking your Sun sign horoscope, you’re only getting a piece of the message — not the full picture. Astrology is house-based, not sign-based. That means if you want to understand: • da
Mystic Min9dz

Mystic Min9dz

849 likes

Master Excel with CTRL + Series Shortcut! 📊✨
👉 Welcome to Our Excel Mini-Class! 💡 Hey, Excel warriors! 💪 Ready to level up your Excel skills and work faster? Today, I’m sharing some essential CTRL shortcuts that will make your life soooo much easier. Whether you're a student or a professional, these are game-changers! 🏆✨ ✨ Pro Tip:
WPS Office

WPS Office

1 like

Excel permanent timestamp
Time stamps DO NOT update when you close and reopen #excel #exceltips #templates #tutorial #exceltraining
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

23 likes

An outdoor dining scene with people seated at tables, featuring the overlaid text "Freeze the Top Row in Excel." A purple glass is visible in the foreground on a black mesh table.
A light beige background with black text asking, "Do you ever have hundreds of rows of data and when scrolling down, you loose sight of the column header and forget which column/field is which?"
A light beige background with black text stating, "This is when freezing your top row is crucial! I will show you how!"
HOW I FREEZE THE TOP ROW IN EXCEL
The ability to freeze that first row of my column headers has been a lifesaver, allowing me to scroll through thousands of rows of data without losing sight of my column headers/fields. By simply selecting the row below the one you want to freeze, heading to the "View" tab, and clicking
Peyton’s Place

Peyton’s Place

105 likes

A person's hands on a Mercedes-Benz steering wheel inside a car, with a city skyline and traffic at dusk visible through the windshield. Overlaid text reads: "Achieve personal and professional excellence with The Pyramid of Success. The graph and how to apply it to real life."
A detailed diagram of "John Wooden's Pyramid of Success," illustrating various qualities like Industriousness, Friendship, Self-Control, Skill, and Competitive Greatness, leading to "SUCCESS" at the apex. Surrounding text explains Wooden's definition of success.
A clear diagram of "The Pyramid of Success," with "Success" defined at the top. The pyramid is built from foundational blocks like Industriousness and Enthusiasm, progressing through tiers of qualities such as Self-Control, Skill, and Poise, culminating in Competitive Greatness.
If You Want Success Follow This Chart
If you have no idea what success looks like for you or where to start on your journey begin here and apply these principles to get to your goals. #visionarymindset #successskills #success #richgirlhabits
Victoriarose Vargas

Victoriarose Vargas

613 likes

The image displays a laptop, a lit candle, and a lamp on a bedside table, with a mirror reflecting a bed. Overlay text reads "Changing Axis Colors in Excel" and "SWIPE," indicating a tutorial.
This image presents an Excel bar chart titled "Actual" showing monthly data from May to September. The Y-axis, representing percentages, has the "5%" label highlighted in red, demonstrating a custom axis color. Text asks how to achieve this effect.
The image shows a screenshot of the Excel "Format Axis" pane, focusing on the "Number" section. It illustrates selecting "Custom" category and entering a format code like "[Red][=0.05]0%;0%;0%" to color a specific percentage value on the axis.
HOW I CHANGE AXIS COLORS IN EXCEL
In my search for more dynamic and visually impactful data representation, I found a powerful feature in Excel – the Format Axis Number Custom Format Code option. This tool allows me to not only present numerical data but also customize the display to highlight specific values. The ability to chang
Peyton’s Place

Peyton’s Place

64 likes

Excel Cheatsheet: 7/20:the ultimate excel shortcut
I discovered this amazing Excel Cheat Sheet that's been a game-changer for me. It's like having a secret weapon in my academic arsenal. 🧠 #excelspreadsheets #cheatsheet #dataanalytics
valder

valder

183 likes

A protein chart displaying various food items like chicken, eggs, cottage cheese, pork chop, Greek yogurt, lean beef, salmon, chicken drumstick, chicken thigh, ahi tuna, black beans, lentils, chickpeas, peas, pumpkin seeds, tofu, shrimp, bison, NY strip, and rib eye, along with their respective protein content in grams.
PROTEIN CHART!
#protein #mealprep #meals #musclebuilding #food
Alexis 🍋

Alexis 🍋

918 likes

Excel list comparison 🌸
So we have to use something called Planbook at work (Teacher). I think this will make me want to actually use it more, and I can see me changing it again before second semester begins lol. How cute is this?! I’d usually do random colors, but love the pink & green combo. #Planbook #
Hey 😁

Hey 😁

4403 likes

Let’s break these excel habits
Do you consider this proficient in Excel?? I can tell you it’s not. My office survival course is for you and can be done in as little as a weekend or during lunch for a week. #exceltraining #tutorial #excel #exceltips #exceltipsandtricks #exceltricks #onlinecourse
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

36 likes

1/3: Ultimate Excel Cheatsheet You Should Know
Hey there, I've got just the right boost for your Excel game. 🌟 📝 The Journey from Junior to Senior: My Excel Cheatsheet Chronicles I've been there, struggling with the basics and wondering how to climb the Excel ladder. But fear not, because I've distilled my journey into a one-p
Valder

Valder

528 likes

A hair length chart featuring a woman with long, dark hair, illustrating various hair lengths from 10 inches (neck line) to mid-thigh. The chart provides a visual guide for hair growth, marking lengths like shoulder, mid-back, and waist.
your quick hair length chart 💗
what length is your hair at right now? ✨ -SAVE for reference! mine is mid back and i'm going for waist 😊 @stylingbykit @Kit #hair #hairgrowth #haircare #longhair #stylingbykit
Kit

Kit

791 likes

HOW I CREATE SPARK-LINES IN EXCEL
What is a sparkline? A sparkline is a small, simple, data-intense graphical representation typically used in line with text to show trends, variations, or patterns in data at a glance. Creating a sparkline in excel is pretty simple. I highlight a range of horizontally organized data and go into
Peyton’s Place

Peyton’s Place

319 likes

Quick sum in 3s
#hellolemon8 #excel #excelx #exceltips #spreadsheets
Excel.dashboard.queen

Excel.dashboard.queen

1 like

Excel tip to remove chart backgrounds
Get rid of the background and outline on Excel charts #tutorials #excel #exceltips #exceltricks #businesstips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

6 likes

Options 101: Understanding Chart Gaps
Think of a gap on a stock chart like a sudden jump or drop in price from one day to the next, with nothing in between. This happens because stocks don’t trade continuously when the market is closed. For example, if some important news comes out after the market closes, earnings or heavy changes,
Chaymeriyia

Chaymeriyia

355 likes

A woman takes a mirror selfie, holding a coffee cup and phone, with text overlay 'EXCEL SHORT CUTS SAVE TIME & FRUSTRATION PART 1'. Abstract shapes frame the image.
A beige graphic slide explains the Excel shortcut 'SHIFT + END + DOWN' for selecting an entire column or section of data, with a 'SWIPE' indicator.
A brown graphic slide details the Excel shortcut 'CTRL + A' which selects all data in a worksheet, accompanied by a 'SWIPE' instruction.
EXCEL SHORTCUTS
These excel short-cuts are just a few that have made my excel work take a fraction of the time and genuinely changed my work life!! Working in excel can be extremely frustrating when not using the tool efficiently. Here are some crucial shortcuts to enhance your experience with Excel. CTRL + A
Peyton’s Place

Peyton’s Place

2586 likes

Separate tab for excel notes
Keep your notes to yourself with excel camera #tutorial #excel #exceltraining #exceltricks #business #exceltutorial #exceltips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

33 likes

Excel projects with a Gantt chart
Auto populate the Gantt style chart with name and color #template #excel #tutorial #friday #exceltips
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

11 likes

Add Headers to Every Printed Page in Excel! 📄✨
🙌 Welcome to Our Excel Mini-Class! 💥 Hey Excel enthusiasts! 👋 Tired of scrolling and losing track of important info? 😱 Freeze the first and last rows to keep those key details locked in place! Here’s how you can add headers to every printed table page so your work always looks clean and polishe
WPS Office

WPS Office

6 likes

🥤 Fruit + Veggie Smoothie Chart: Glow & Detox Blend 🌿✨
Balance is key 💚 This fruit + veggie smoothie chart gives you the best of both worlds—natural sweetness from fruits and powerful nutrients from greens. Perfect for glowing skin, better digestion, and daily energy, these blends help you fuel your body the healthy way. Save this chart and upgrade you
Kae Milian

Kae Milian

804 likes

My Small Knotless braid sizing chart for beginners
bawsee.ee

bawsee.ee

762 likes

EXCEL SHORTCUTS PART 3
As requested, here is another excel shortcut post! Discovering the power of Excel shortcuts has been a game-changer for my productivity at work. These little keystrokes might seem insignificant, but they're the key to working smarter, not harder. From navigating vast datasets quickly to instant
Peyton’s Place

Peyton’s Place

331 likes

Excel ABC
Excel shortcuts are easy to remember with cheat sheets like the ABC’s. These are some of the most common shortcuts to use. #excel #exceltraining #exceltips #exceltricks #excelpro #alwayslearning
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

33 likes

Excel import magic
Excel magic at its finest. Import data from picture whether it’s a photo from your phone or a screenshot. #tutorial #exceltips #exceltricks #exceltraining #exceltutorial
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

363 likes

Name cells in excel
Customize and store headings in Excel #exceltips #tutorial #exceltraining #exceltricks #exceltutorial #excelforbeginners #learn Takw my Excel class xecutethevision.com#onthisday
Excel tips at XecuteTheVision

Excel tips at XecuteTheVision

31 likes

Monthly Calendar Spreadsheet Excel & Google Sheets
Plan your entire month in one clean spreadsheet. This monthly calendar template helps you organize appointments, goals, reminders, and tasks without switching between apps. Works in Excel and Google Sheets, so you can plan wherever you prefer. Just download once, open it, and start organizing yo
Loving.Templates

Loving.Templates

0 likes

Useful Excel Formulas to save your time at work!
Hey everyone! Excel formulas are awesome for speeding up calculations and analyzing data. They range from simple math stuff to more complex tasks like searching and matching data. Learning these formulas can make your work easier and help you get more done in less time. Try out online tutorials and
Yun Jung

Yun Jung

868 likes

Fast Task Tracking in Excel! 🏃‍♂️✅❌
✨ Welcome to Our Excel Mini-Class! ✨ Hey productivity champs! 🙌 If you’re juggling multiple tasks and need a simple, fast way to track your progress, I’ve got the perfect Excel trick for you! 📊✨ Let’s set up a Done/Not Done Tracker that will keep your tasks organized and help you stay on top
WPS Office

WPS Office

4 likes

Blank EXCEL template for school nurses!
As a school nurse this isn’t perfect but I wanted to share it anyways. It is a BLANK excel template for students with health conditions. Just click and request access. Is there any other templates you’d like to have access to or need ? 1. Click my link tree in my bio!!! Click on drop down arrow
Officialtiktoknurse

Officialtiktoknurse

40 likes

Excel's Most Powerful Trick-Ctrl+E
📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re unlocking the magic of Ctrl+E—your new best friend for saving time! ⏳ Whether you’re working with big datasets or just need to clean up information, this shortcut will help you instantly fill in
WPS Office

WPS Office

150 likes

See more