+ Reply to Thread
Results 1 to 16 of 16

Connecting points in a graph

Hybrid View

  1. #1
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Connecting points in a graph

    OK, I've had a look at the Word doc. I see two charts with many data points. They look great. A JPG of GIF of the same screenshot would have taken a less lot bandwidth, by the way.

    I don't see any explanation of what you want to achieve and no examples of what you want to do, nor any logic that leads to the results, which aren't illustrated anyway.

    What to do? Create a sample Excel file with just a few data points that follow the same principles as the chart in your Word file. Create the chart that goes with it. Use dummy data. Then upload that file here and explain what you want to do. Use the drawing tool to create lines that you can't create within the chart. Explain the logic that leads to the lines.


  2. #2
    Registered User
    Join Date
    01-05-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Connecting points in a graph

    Ok, its was a bit difficult as all the value are plotted with calculated values from various sheets. Here's the sample. What i would like to achieve is the one with the blue line. The caps and the point itself has to have a parallel line till it almost reaches the next range. X-axis is the range.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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