+ Reply to Thread
Results 1 to 3 of 3

Graph

  1. #1
    Registered User
    Join Date
    01-23-2005
    Posts
    2

    Question Graph

    There is probably a really easy solution to this, but I just can't figure it out!!!

    I performed an investigation, which was to return a certain percentage of data (e.g. 1%, 2%, 5%, 10%, 25%, 50%, 75% or 100%) and time how long it took for the data to be displayed to the screen. I performed the investigation on each percentage twice, so I now have two sets of results for each percentage.

    I would like to display these results in a line chart, but Excel won't let me arrange the line chart how I wish. I would like the time taken to be in the X axis and the percentage to be in the Y axis.

    No matter how many different ways I try, I cannot get this to happen. I have tried drawing my table of results with the percentages along the top and then down the side, I've tried adding in extra series and then taking them out after the graph has been drawn, but nothing works.

    If anyone could advise, I would be so grateful.
    Many thanks.

  2. #2
    Registered User
    Join Date
    01-23-2005
    Posts
    2
    Have you tried using the scatter graph instead of the line graph? You can still join up the points with lines. I think Im probably being a bit too simple here, but that just reminds me of a problem I had recently and i realised i was using the wrong type of chart!

  3. #3
    Registered User
    Join Date
    01-23-2005
    Posts
    2

    Thank you

    Many thanks. I'll give it a shot.

    Thank you

+ 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