Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel charts (2003)

    I need a chart to demonstrate quality v customer service.
    So if y is quality and x is customer service and Fred is 4 = quality 2 = customer service I want my marker to appear 4 points up (y) and 2 points across (x). The bubble gets me there but then makes the bubbles different sizes - is there any way of keeping them the same - or is there an alternative chart type I could use?
    Regards
    Roberta

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel charts (2003)

    Use the xy scatter chart for this.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel charts (2003)

    Unfortunately this gives me a data point for Quality and another for Customer Service. I am loooking for one data point which reflects both. If each range from 1 to 6 and I have a 1 for quality (x) and 6 for customer service (y) I would hope to find the data point in top left of the chart. If I have 6 for quality (x) and 1 for customer service (y) I would hope to find a data point in the bottom right of the chart.

    I think I am going to end up drawing something in powerpoint!!!

    Thanks anyway - Roberta

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: excel charts (2003)

    Does the attached workbook do what you want? I created an XY scatter chart based on columns B and C, then used Rob Bovey's free add-in XY Chart Labeler to add data labels based on column A.

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel charts (2003)

    Many thanks this has solved my problems - apologies for the delay in thanking you BT cancelled my broadband order on moving house and have only just got reconnected!!

    Regards

Posting Permissions

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