+ Reply to Thread
Results 1 to 8 of 8

add oval ring shape in chart excel

  1. #1
    Registered User
    Join Date
    05-08-2022
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    6

    add oval ring shape in chart excel

    hello, I'm working on a conveyor belt coupon tracking and I use a classic tracking sheet (pic attached). Is it possible to create a chart in an oval ring fueled by a table of Excel data?
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: add oval ring shape in chart excel

    Probably best draw with shapes or a picture. Both of which can be placed within a chart object.

    What parts of the graphic would change based on your data?
    If it's the text then that could be done with xy-scatter series and data labels linked to cells.
    If it's the shading of segments on the track that is a little harder. You could create custom data markers to match the segment and again use xy-scatter to position markers. If the colour changes to more than 2 colours you will need a series for each colour.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-08-2022
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    6
    thank you for your responsiveness,
    To clarify my request, you will find attached the work file.
    I want to create oval ring chart instead of circular ring
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: add oval ring shape in chart excel

    There is no built in chart that will create an oval.

    As I said you will need to create it your self using shapes or a xy-scatter chart with custom markers.

    You have not explained what it is about the data that you want to show.
    Do the lengths change?
    Do the colours change?
    Do the descriptions change?

    The best approach is dependent upon what is changing.
    If the lengths change then shapes and VBA code will be needed.

    if it's just text then a charts data label maybe sufficient.

    If you use a chart it will need to be a xy-scatter where the data markers are custom shapes. You will need to create the custom shapes, apply them as markers (single data point at a time)
    and work out the x and y position to make the oval shape.

  5. #5
    Registered User
    Join Date
    05-08-2022
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    6

    Re: add oval ring shape in chart excel

    Hello andy pope,
    Actually the change is by length and color.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: add oval ring shape in chart excel

    The the only way would be VBA and shapes.

    Those on the curved section will be the hardest but you should be able to use Arc's

  7. #7
    Registered User
    Join Date
    05-08-2022
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    6

    Re: add oval ring shape in chart excel

    Thank you very much, this is a chance to start learning vba first.

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: add oval ring shape in chart excel

    I would start with doing it manually to make sure you get the effect and control over it that you need, before worrying about learning VBA

+ 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. count oval shape for each name and merge for repeated name
    By Mussa-A in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2021, 09:13 AM
  2. Labels of zero values show up in ring chart
    By Blacko in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-08-2018, 09:23 AM
  3. [SOLVED] Add Shape (arrow) to an Excel Chart AND auto re-position
    By grcaz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2017, 08:42 AM
  4. Doughnut Chart, Different Ring Heights (Widths?)
    By yay_excel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-25-2016, 04:29 AM
  5. [SOLVED] How to add 3d bevel (Cool Slant) shape effect to Oval shape
    By Steve@Rugby in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2013, 11:29 AM
  6. Graph in a oval shape
    By coreytroy in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-22-2013, 02:57 AM
  7. [SOLVED] Adding shape-type textbox into excel chart sheet
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2006, 03:30 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