Polar Plots

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(1)  Select D2:E3 and make an XY chart

(2)  Select D5:E6, click on the Copy tool, use the menu command Edit | Paste Special and
specify  (a) New Series, (b) Values in Columns, (c) Categories values in first column – see figure above.

(3)  Repeat step 2 with D8:E9

(4)  Format chart objects (data series, axis, etc) as required

Click here for sample Excel file

 Return to Excel Tips and Tricks