Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
seeker
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Point labels in an Excel scatter plot to be associated text Point labels in scatter plot - text? Charts and Charting in Excel 4 April 29th 23 07:45 PM
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting in Excel 6 April 3rd 23 06:58 PM
how can i open multiple excel sheets separately srinu Excel Discussion (Misc queries) 1 July 8th 05 04:38 PM
Sort rows across multiple worksheets - Excel 2003 Stamdale Excel Worksheet Functions 2 July 5th 05 04:30 PM
Exporting from Excel to multiple XML files Questions Excel Discussion (Misc queries) 0 March 17th 05 11:20 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"