T055 Sweet Gauge and Bar Chart

📌 Compatible with Microsoft Excel 2013 and above.
📌 This file contains VBA (Macro) code—please enable macros before using the template. (See instructions in the ‘Videos’ menu.)

⚠️ Remark
📌 The graph may move slightly depending on each computer setting/specification. This can be fixed simply
by clicking the unlock button and adjusting the graph manually.
📌 If your computer doesn’t have the font specified in the template, the display may not exactly match the image shown. However, most of our templates use the font that comes with Microsoft Office 365.

✅ Graph automatically adjusted according to input numbers.
✅ Adjust full mark accordingly to your needs.
✅ Change input format (Number, Currency, Percentage).
✅ Hide Title, Sub Title.
✅ Add/remove graphs automatically according to the input.
✅ Change the chart color and change back to the default color conveniently by pressing buttons.
✅ Randomly select chart color conveniently by pressing buttons.
✅ Increase or decrease gauge limit (Target) as desired.
✅ Hide Target on Gauge Chart if not needed.
✅ Adjust Bar Chart conner as needed (round corners).
✅ Add images and icons.
✅ Copy all charts and paste them into PowerPoint or other programs.
📖 A detailed user manual is in the file (In Thai but buttons are in English and easy to understand).

✅ In addition to the automatic buttons, able to unlock to move or modify parts of the graph as needed.
✅ Suitable for Advance users only, please proceed carefully as it may cause an error.
❌ Can’t add more charts or insert rows/columns on the Template sheet.
❌ VBA code is locked and cannot be edited.

🎥 Related videos

📌 How to Enable Macro (First-time use)
https://youtu.be/1xylozkx4NA

📌 Beginner’s usage guide
https://youtu.be/ipLadGzGriE?si=MUxeHECRPxhSfaxI

📌 Implementation ideas
https://youtu.be/vI6X8VFN1ss?si=0TDF9nXUr1UEYOMT