+ Reply to Thread
Results 1 to 1 of 1

Hide or delete a single division line in a radial chart

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    Ciudad de Panama, Panama
    MS-Off Ver
    Excel 2003
    Posts
    1

    Hide or delete a single division line in a radial chart

    Hello everyone

    I made an MS Excel program to calculate forces in reinforced concrete tunnels.

    I have made radial charts to graph the values of moment, axial force and shear force.

    I modified the scale of the charts to 15000 max and -15000 minimum and the greater unit to 15000 so I don't have that many radial division lines.
    By doing this, I can make the line that represents "zero" be a single line; however, MS Excel will still plot an outside radial division line representing the 15000 value.

    I have tried making "zero" to be the greater unit in the chart scale but Excel says the number has to be greater than zero.

    I would like just the zero radial line to appear, because it would represent the tunnel itself. And I would like to have the outer division line to be white or if possible to not show at all, so it would be hidden in the chart.

    I tried drawing a white donut shape to hide the outer line but whenever I change the tunnel diameter in my excel program, the chart changes and the donut shape would have to be redrawn again.


    Here is one of the charts:

    Tunnel moments.jpg

    Could someone here have any ideas on how to hide the outer division line? Can it be done?

    Thank you
    Attached Images Attached Images

+ 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. How to create single marker on the line chart?
    By nelsonys in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 07-28-2009, 08:50 AM
  2. Single line chart with multiple colors
    By impius1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2007, 06:58 PM
  3. Different colors on a single line chart
    By Sarah in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-31-2006, 05:25 PM
  4. A mjultiple Line/Data on a single chart
    By Rochelle B in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2005, 10:25 PM
  5. [SOLVED] how to hide zero values on line chart
    By MikeM in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-07-2005, 09:05 AM

Tags for this Thread

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