Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    We are working with data for Copper (dissolved) and Copper (Total) that was measured over a range of dates (5/5/1991-7/7/1991 or 9/7/2001-9/10/2006, etc.). The engineer wants a chart showing all the values measured during each range of dates as vertical dots with the x-axis displaying the date range. The scatter chart gives us the closest results, but only if we use one date for the x-axis. There is data over several date ranges from 1991 to 2009. The attached is sort of the chart that is wanted, but they want the date range displayed as x-axis labels.

    Maybe I will need to just manually put the ranges in as text boxes, unless you have a better idea.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You did not attach the worksheet file....

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Sorry, I must have forgotten to click Upload file button.
    Attached Files Attached Files

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I would use a dummy X-axis and offset the 2 measurements. Then not display the labels and create text labels for the year.

    If appropriate I would also consider comparing the 2 methods and then investigate the points that have large deviations...

    (see attached)

    Steve
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •