Watch the video above...
#speedometerchart #gaugechart #pakuppaivu
Project Completion status, On-Time Delivery, Percentage rejections, Units produced per hour, etc can be shown using gauge chart / speedometer chart. Creation of gauge chart / speedometer chart may sound difficult and many of you thinks that it requires specialized #datavisualization software but we are showing you through this video that we can easily create speedometer chart / gauge chart in #Excel
#ComboChart in Excel helps us to create this chart with simple few steps, we have also shown the usage of #datavalidation in Excel in this video
00:00 Introduction about Speedometer chart / Gauge chart
01:44 Setting up to create Speedometer chart
02:58 Custom Combo Chart
03:40 Combo Chart to Speedometer
06:50 Formatting Speedometer
08:05 Data Validation
10:05 Text Formatting
11:55 Changing Speedometer Scale
13:03 Conclusion
If you have any queries please mention it in comment section...
No comments:
Post a Comment