Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   XML (https://www.askmehelpdesk.com/forumdisplay.php?f=448)
-   -   Query on Excel (https://www.askmehelpdesk.com/showthread.php?t=253515)

  • Aug 27, 2008, 03:38 AM
    vbg1980
    Query on Excel
    I'm really confused now about creating a chart in Excel - yesterday I thought I was an expert!

    Anyway, please help me with the following:

    I want to create a scatter diagram (displaying x and y values at any one time). What I get is a vertical kind of diagram, with the values of X and Y. So that's fine. At this point, I want to give a name to the points and don't want to do it manually - is there a way of doing this? I paste below the info of what Im trying to do:

    Grade Service
    Anne -15% 43%
    Katie -13% 81%
    Nisha -11% 62%
    Aidan -8% 67%
    Martha -7% 67%

    Thanks for helping!! :)
  • Aug 27, 2008, 05:41 AM
    ebaines
    1 Attachment(s)
    Like this? I think the only way is to enter each point as its own series on an XY scatter plot - then you can specify that you want the points labeled with their series name. It's a bit time consuming.
  • Aug 27, 2008, 06:06 AM
    vbg1980
    Yes. You're right - it is time consuming! I thought excel had a faster way of doing this, but now you have just reassured me that its not the case. THANKS!!

  • All times are GMT -7. The time now is 02:08 AM.