Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need multiple revolutions on radar plot in Excel
I am trying to plot an Archimedes spiral with the radar plot in Excel and can
only obtain one revolution. I need multiple revolutions and would also like to have multiple arms in the spiral. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need multiple revolutions on radar plot in Excel
Create a series for the Category(X) axis labels
that goes from 0 to almost 2*pi() Just how close to 2*pi() depends on the number of data points. Very tricky. Generate the radius values for these radians and plot. For the second revolution, generate the radius values for 2*pi() to almost 4*pi() and plot, using the original Category(X) axis labels. The lines will not join correctly, so just show markers. To have the lines join smoothly, use XY scatter plot instead. Convert to X, Y values with =COS(radians)*radius and =SIN(radians)*radius Use a different series for each revolution. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Point labels in an Excel scatter plot to be associated text | Charts and Charting in Excel | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
how can i open multiple excel sheets separately | Excel Discussion (Misc queries) | |||
Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions | |||
Exporting from Excel to multiple XML files | Excel Discussion (Misc queries) |