Indy Acoustic Research
  • Home
  • People
  • Services
    • Consulting
    • Testing
    • Product Design
  • Blog
  • Contact
  • Employment

Polar Plots Using Excel Radar Chart

10/14/2015

 
Picture
​Excel is a great tool for engineering data reporting due to its widespread use. However, it has never supported a good polar plot which is an essential plot type in multiple engineering disciplines, including acoustics.  The major workarounds I’ve seen are to either download a plugin (which is difficult if you don’t have admin rights) or convert (theta,R) into x=R*cos(theta) and y=R*sin(theta) and use a scatter plot. However, the latter method can take up a lot of spreadsheet space -especially if you have multiple sets of data.
 
It turns out the chart type that you always thought should be able to plot a polar – the Radar Chart – CAN do it; however, there is still some frustration with the formatting of axes. Thankfully, if you work through the frustration once and save the completed chart as a template, it’s much easier to reuse future data sets. See the below attachment for instructions using Excel 2016. There are some differences with older versions, but hopefully you can follow along also...
​
iar-_polar_plots_in_excel.pdf
File Size: 493 kb
File Type: pdf
Download File


Comments are closed.
    View my profile on LinkedIn

    RSS Feed

    Archives

    December 2021
    July 2021
    March 2021
    January 2021
    March 2020
    January 2019
    March 2018
    October 2017
    March 2017
    December 2016
    April 2016
    November 2015
    October 2015
    September 2015
    July 2015

    Categories

    All
    Equipment
    Excel
    Glenn Hess
    Larry Marcus
    Marc Reese
    Shannon McConnell
    Simulation
    SoundCheck
    The Lab
    Tricks Of The Trade

Copyright ©2015-2022 Indy Acoustic Research LLC. All Rights Reserved.
​