+ Reply to Thread
Results 1 to 4 of 4

Radar chart with multiple center.

  1. #1
    Registered User
    Join Date
    05-19-2019
    Location
    Cluj
    MS-Off Ver
    2016
    Posts
    2

    Radar chart with multiple center.

    Hello,

    I need to create multiple radar chart that is overlay with an specific distance between center and i don't have any ideal how to do it.

    Here is an photo to make an idea.(sorry for the bad image)radar.png

    Thank you.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,743

    Re: Radar chart with multiple center.

    I don't think you are going to get this as a radar chart. I would expect to make a chart like this as a scatter chart, with each color as a separate data series. Are you familiar with scatter charts?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    05-19-2019
    Location
    Cluj
    MS-Off Ver
    2016
    Posts
    2
    Quote Originally Posted by MrShorty View Post
    I don't think you are going to get this as a radar chart. I would expect to make a chart like this as a scatter chart, with each color as a separate data series. Are you familiar with scatter charts?
    Yes, but let me explain for what i need the chart first, i have an robot that make 360 read distance form 10cm to 10 cm and i need to map the read . If you can give me some tips on how to make scatter chart , i will be happy to used .

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,743

    Re: Radar chart with multiple center.

    What "tips" do you need? I find that a lot of charting questions end up being more about building the spreadsheet than creating the chart itself. Assuming that you have the data or can calculate the x,y position data, I would expect to arrange the data for one robot like this (x0,y0 is the central/home position):
    Please Login or Register  to view this content.
    Note how the "home" coordinates are repeated between each point.

    With the data arranged like that in the spreadsheet, creating the scatter chart should be as simple as selecting the data and inserting a scatter chart (straight line, no marker). After creating the scatter chart with the data for one robot, use the Select data dialog to add additional data series for the other robots.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Chart Radar Chart Labels Problem
    By jancliff in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-12-2021, 12:11 AM
  2. radar chart filled with gradient at center point
    By alanb1976 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-10-2016, 11:09 AM
  3. [SOLVED] Radar Chart - series chart type conversion issues
    By Prince Dakkar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-20-2015, 08:44 AM
  4. RADAR chart
    By Doron in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-21-2009, 06:40 AM
  5. Filled radar chart with multiple series
    By MSP77079 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2007, 08:43 PM
  6. Radar Chart
    By Angus Robinson in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-24-2005, 12:05 AM
  7. [SOLVED] Radar Chart with Multiple scales
    By Amanda in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-16-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1