Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Scatter Chart ? (Excel 2002)

    Hi

    I am trying to create a scatter chart to sum values, based on text in an adjacent cell.

    Please see attached.

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

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

    Re: Scatter Chart ? (Excel 2002)

    A scatter chart doesn't make much sense here - a chatter chart is used if the x axis values are numeric.

    In fact, the whole chart doesn't make sense to me. The way the points are plotted suggests a non-existent relation between the two series. What do you want to happen if there are more "A"s than "B"s?

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Scatter Chart ? (Excel 2002)

    Hi Hans

    This is inherited but the person who created it sorted by ABC then applied the data just selecting the As Bs Cs and Ds, It doesn't matter if there are more As or Bs,
    Also it doesn't have to be a scatter chart, I just want a graph that shows the values of all the A's B's etc. The A's B's etc will vary every month.

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scatter Chart ? (Excel 2002)

    Hi Braddy could you use the sumif function similar to this:

    =SUMIF(I2:I100,"A",K2:K100)
    =SUMIF(I2:I100,"B",K2:K100)
    =SUMIF(I2:I100,"C",K2:K100)
    =SUMIF(I2:I100,"D",K2:K100)

    Place them in adjacent cells and use a bar chart to show the sum of NIV.
    Jerry

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Scatter Chart ? (Excel 2002)

    You could just use a pivot chart, as in the attached demo. Note that pivot charts tend to lose any manual formatting when you refresh them so, if that's an issue, create a standard chart based on the pivot table rather than an actual pivot chart.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Scatter Chart ? (Excel 2002)

    Hi Rory

    Sorry I did not get back to you, I was gently reminded by Hans of my miscarriage of protocol.

    Thanks for your suggestion, but it appears you cannot create a scatter chart from a pivot table.

    Braddy
    If you are a fool at forty, you will always be a fool

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Scatter Chart ? (Excel 2002)

    Braddy,
    That is true but then, as already suggested, a scatter chart doesn't appear to make sense for what you are doing! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Scatter Chart ? (Excel 2002)

    HI Rory

    Unfortunatley a scatter chart is the the last chart I would select for this, however the accountant insists on this is what he wants.

    With Steves help yesterday I think I can appease him.

    Thanks for your interest.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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