Excel - Dial as XY Chart: Episode 1711
1,163 views · Published 16 May 2013 · 5:20 · Indexed 23 October 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: How to Create a Dial Chart Using an XY Chart in Excel | MrExcel Podcast. Welcome to another episode of the MrExcel podcast! In today's episode, we will be discussing how to create a dial chart using an XY chart in Excel. This topic was suggested by one of our viewers, Raed from Northern Kentucky, who asked if it was possible to create a dial chart using an XY chart. So, let's dive in and see how it's done! In yesterday's episode, we showed how to create a dial chart using a pie chart and a clever trick from Dietmar in Germany. However, Raed pointed out that it could also be done using an XY chart. This got me thinking, could we really create a dial chart using an XY chart? So, in today's episode, we will explore this idea and see how it can be done. To start off, we will create a unit circle using a scatter chart. We will use degrees in column A, as that is what we are familiar with from our high school geometry classes. However, computers think in radians, so we will use the =RADIAN function to convert the degrees into radians. Remember, there are 2PI radians in a circle, which is equivalent to 6.28 radians. The X point will be the cosine and the Y point will be the sine, which will give us a perfect circle when plotted on an XY chart. Now, the challenge is to add a pointer to the chart. To do this, we will add one more point at 0,0 and make sure that the circle ends at the correct spot. This can be achieved by subtracting the value of F3 (25%*360) from 90. This may require some experimentation, but once you get it right, the pointer will appear at the top of the circle. We can then clean up the chart by removing the legend, title, gridlines, and axis. This will give us a clean and compact unit circle chart with the extra point for the pointer. The advantage of using this method is that we can easily adjust the size and thickness of the line to make it more visually appealing. This can be especially useful when creating multiple dial charts on a dashboard. I know that some people may not be fans of dial charts, but sometimes our managers insist on using them. In such cases, the XY chart method can be a great alternative to the traditional pie chart method. So, thank you Raed for suggesting this approach and I hope it will be helpful to our viewers as well. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Dial Chart Using Scatter Chart (00:19) Dietmar's trick from Germany (00:30) Can it be done with an XY chart? (00:40) Creating a unit circle with a scatter chart (00:51) Converting degrees to radians (01:07) Plotting the unit circle on an XY chart (01:49) Adding a pointer to the chart (02:09) Adjusting the chart to display the pointer correctly (03:05) Cleaning up the chart (03:37) Advantages of using an XY chart for dial charts (04:30) Changing the chart size and line weight (04:58) Conclusion and thanks to Raed (05:08) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #tutorial This video answers these common search terms: Adding pointer to XY chart in Excel Changing line weight in Excel chart Converting degrees to radians in Excel Creating scatter chart in Excel Creating unit circle in Excel Customizing Excel scatter chart Excel dial chart Removing gridlines from Excel chart Removing legend from Excel chart Removing title from Excel chart Using XY chart for compact dashboard visualization XY chart in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153532/ Raed makes Bill pull out some High School Geometry from 1981 to re-do yesterday's Dial Chart as... an XY Scatter Chart. Today's Podcast, Episode #1711 has something for everyone; Math Zealots, Graphing Geeks, Chart-Heads, Performance Enthusiasts, Pac-Man Devotees, Minimalists, Vector Art Visionaries.... all in the name of showing a Chart type that I still do not like. (But Bill does say, however, "...if your crazy Manager is making you create these Dial Charts, this version does scale down much better than yesterday's Episode. Need Chart and Graph information? Use Excel 2013's radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly... so you drive your message home, and get the decisions and actions you're looking for! Charts and Graphs Excel 2013 by Bill Jelen http://www.mrexcel.com/store/index.php?l=product_detail&p=256 www.MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920