+ Reply to Thread
Results 1 to 4 of 4

Create Circular Major Segment Graph

  1. #1
    Registered User
    Join Date
    07-28-2019
    Location
    Jakarta
    MS-Off Ver
    2016
    Posts
    2

    Create Circular Major Segment Graph

    Hello, I am newbie at Excel and only knew some of its function. Could anybody tell me how to make graph (with given data) like below without using VBA code:
    Untitled-2.gif
    I already make the graph for the circle and lines but that is as far as I know. Sorry for my bad English.
    Attached Files Attached Files

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

    Re: Create Circular Major Segment Graph

    What are the essential elements to this chart and what details are optional? How would you like to change the chart in your sample file? You have already drawn the circle, the chord, and the diameter (I am a little confused by your diameter because your chart shows the diameter as 30 mm, but your input data shows the radius should be 30 mm).
    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
    07-28-2019
    Location
    Jakarta
    MS-Off Ver
    2016
    Posts
    2

    Re: Create Circular Major Segment Graph

    Quote Originally Posted by MrShorty View Post
    What are the essential elements to this chart and what details are optional? How would you like to change the chart in your sample file? You have already drawn the circle, the chord, and the diameter (I am a little confused by your diameter because your chart shows the diameter as 30 mm, but your input data shows the radius should be 30 mm).
    Oh yeah sorry, at cell M8 it should be =M14*2 and titled 'd' and '0.5d'
    The graph must only show the major segment area. Coordinate (0,0) as tangent point. And I can only change the radius and angles as shown in the picture (yellow cell in excel file).
    Last edited by ahhus21; 07-30-2019 at 05:20 AM.

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

    Re: Create Circular Major Segment Graph

    I'm still not sure I fully understand. To remove the arc from behind the chord, I would just change the circle drawing range so that it knows when to stop drawing the circle.

    1) I need to know the angle from the center of the circle to the end of the chord. You have already calculated the end point of the chord in Q4 and R4, so a simple ATAN2() function will give me this angle =ATAN2(Q4-P8,R4-Q8). You are doing all of your angles in degrees (instead of the native radians that Excel's functions use), so nest that within the DEGREES() function =DEGREES(ATAN2(...)). I also need this to be between 0 and 360 instead of -180 to 180, so I nest that inside of a MOD() function =MOD(DEGREES(ATAN2(...)),360)
    2) I would start drawing the circle from the origin, so I change the starting angle in T3 from -90 to M12-180.
    3) It looks like your current strategy for drawing the circle is to add 15 degrees to each point until you have gone through all 360. Change this so that, instead of going all the way around the circle, stop when you reach the angle at the end of the chord calculated in step 1. In T4, I enter =IF(T3+15>cell_from_step_1,cell_from_step_1,T3+15). Copy that down to the bottom of column T.

    Is that closer to what you want?

+ 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. Multiple lines in graph for same time frame and same data 'segment'
    By wally_j in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-04-2016, 05:22 AM
  2. Copy Major Units value from graph
    By dtrom26 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2015, 10:40 AM
  3. Using a segment from a pie chart to create another pie chart
    By JulieKT in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 03-26-2015, 06:34 AM
  4. Replies: 3
    Last Post: 11-16-2014, 10:51 PM
  5. [SOLVED] Create A Valid Circular Reference
    By nevi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2012, 08:56 PM
  6. Replies: 2
    Last Post: 01-29-2007, 06:37 PM
  7. Changing the scale major unit in a graph
    By Ant in forum Excel General
    Replies: 2
    Last Post: 02-06-2006, 09:45 AM

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