Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Rocko asked in Computers & InternetSoftware · 1 decade ago

Is there any easy way to chart multiple points on a scatter graph on excel?

I need to compare multiple data on a XY scatter graph. The only way i have found how to do it is by selecting point by point. Do you know any Excel addon or some way do to it faster and easier?

A goofy example of what I need: http://junkcharts.typepad.com/photos/uncategorized...

1 Answer

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    I love xkcd, anyways you can just make a table in excel

    Fruit/Veg........x........y

    Pineapple......-5........3

    Watermelon...-2........1

    Peach............4........5

    select the box of pineapple to 5 and select graph, go to xy scatter, go to series, for x values select -5->4 and for y values select 3->5

Still have questions? Get your answers by asking now.