Results 1 to 3 of 3

create scatter plot with centroids

Threaded View

  1. #1
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    create scatter plot with centroids

    Hi, I wonder if someone can help as i´m quite stuck!!

    I´m trying to create a scatter plot to show groups created from a k means. I have recency, frequency and value variables and 10 clusters.

    I´d like to create the groups in a scatter plot but i´m not sure how to plot the centroids (I575;K584) on the data tab.

    Could someone please take a look and help me out as after googling the heck out of it... i´m still no closer!

    thanks, any help appreciated
    Attached Files Attached Files
    Last edited by Blake 7; 06-09-2015 at 12:21 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trying to create a line/scatter plot of multiple columns (no rows)
    By exoscoriae in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-04-2014, 04:32 PM
  2. Macro to create scatter plot with different data series?
    By mglwd40 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2013, 08:17 PM
  3. How do I create a data break in a scatter plot?
    By khm7x in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-02-2008, 05:56 PM
  4. [SOLVED] How to Automatically Create Scatter Plot Charts
    By Chris Gregory in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-13-2005, 12:05 PM
  5. [SOLVED] how do I create a 3 dimensional plot, for example XYZ scatter plo.
    By pleasehelp in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-28-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1