Results 1 to 9 of 9

X-Y Scatter Chart with min, med and max x-values

Threaded View

  1. #1
    Registered User
    Join Date
    06-20-2011
    Location
    Australia
    MS-Off Ver
    Excel for Mac 2011
    Posts
    5

    Question X-Y Scatter Chart with min, med and max x-values

    I have reached the capacity of my capabilities and need the assistance with creating an Excel Chart.

    I have a table of test data with the following five columns of data: HEADING (Value 1, ....)

    "Data point labels" (A, B, C, D, E)
    "Minimum x-value" (30, 20, 29, 32, 28)
    "Maximum x-value" (75, 80, 90, 71, 68)
    "Median x-value" (52, 48, 45, 55, 59)
    "y-value" (1,4,9,16,25)

    Data rules

    "y-values" will always be between 1 and 25.
    "x-values" will always be between 1000 and 4000000 (4 Million)
    "Minimum x-value" < "Median x-value" < "Maximum x-value"
    "Median x-value" is NOT calculated from the other two x-values"
    With real data there will be between 50 and 100 data points.

    Need from chart

    1. An x-y scatter graph plotting all the data points.
    2. x-values are plotted with the median data point marker sitting on a horizontal bar representing Minimum to Maximum.
    3. Data points are labelled (using XY labeller)
    4. Y-axis labelled as "Risk"
    5. X-axis labelled as "Value"
    6. X-axis to be logarithmic.

    Same thread as raised on Mr. Excel -> http://www.mrexcel.com/forum/showthr...79#post2758679
    Last edited by agilder; 06-20-2011 at 07:02 AM. Reason: Broke two forum rules.

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