Results 1 to 11 of 11
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Scatter graph question (Excel 2003)

    I've made scatter graphs before using 2 variables, for instance, importance and performance. Now they want me to do it for 2 difference stores but i don't think that is possible, to put 2 different stores on the same scatter graphs. I don't know how i would make it unless one was "invisible" and i overlaid them on top of each other with different colored symbols.

    Also, they want me to use the logos of the stores instead of circles or squares or triangles. Is that possible? uggh!!!

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

    Re: Scatter graph question (Excel 2003)

    Could you explain what the chart should look like, or provide an example?

    You can use any picture as marker for a chart series:
    - Open the picture in a graphics editor.
    - Select the entire picture.
    - Copy it to the clipboard.
    - Switch to Excel.
    - Activate the chart.
    - Select a series.
    - Select Edit | Paste, or press Ctrl+V.

  3. #3
    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

    Re: Scatter graph question (Excel 2003)

    Something like this perhaps?

    Select the info for store1 and create the chart
    Select the XY data for Store2, copy it, then select the chart and paste it.

    Select the store1 logo
    Copy it
    select the store1 markers on the chart
    paste

    Select the store2 logo
    Copy it
    select the store2 markers on the chart
    paste

    Steve

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scatter graph question (Excel 2003)

    something like this, with 2 colored markers, one colors pink for store1 and the other yellow for store2.

    But instead of pink squares i want to use the logo for store1 and isntead of yellow triangles i want to use store2's logo.

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

    Re: Scatter graph question (Excel 2003)

    The way you have set up your chart, it's not really a scatter chart - the x axis is categoric instead of numeric.
    See attached version (and sdckapr's reply)

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scatter graph question (Excel 2003)

    ok, I see now. Thank you for the help. I didn't know you could just paste in pictures like that to replace markers. Good knowledge!

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scatter graph question (Excel 2003)

    sorry, another question. What if I want the data labels to show up "Helps me manage my $$" next to the marker/logo? I tried to include that in the source but then it there are too many variables.

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

    Re: Scatter graph question (Excel 2003)

    I don't think that would be a good idea - in the chart based on the sample data you posted, the data points are quite near each other. And would you like to label the points of both data series?

    If you still want to do it, you can use the free add-in XY Chart Labeler by Rob Bovey.

  9. #9
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Scatter graph question (Excel 2003)

    yes, i do use his add-in but I don't understand where I would put this extra column - the "Helps me manage my $$" since the x and y values are accounted for. Where would i put the value for this third column?

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

    Re: Scatter graph question (Excel 2003)

    It doesn't matter - the XY Chart Labeler lets you specify where the labels are located. I have attached the rather unattractive result.

  11. #11
    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

    Re: Scatter graph question (Excel 2003)

    Here is another option: the Bubble Chart.

    The Category is the "Text" (added with a dummy range and data labels), the perfomance is the Y-axis. The Importance is reflected in the SIZE of the logo...

    [I made different X-values for each of the strores to avoid the overlap, but it is clear how they can be compared in the groups, store1 is offset to the left of the center, store2 to the right of the center]

    Steve

Posting Permissions

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