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

But ... what is wrong with the graph you prepared? It looks OK to me.

To not stop just after asking (stupid?) question - have a look on minor addition to outputclusters sub (I made an assumption that there is empty column left to original data (A in your attached file)

   'Print by Row
    rowNumber = rowNumber + 1        'Blank Row
    For r = LBound(Record) To UBound(Record)
        oSheet.Rows(rowNumber).Cells(1).Value = Table.Rows(r).Cells(1).Value
        oSheet.Rows(rowNumber).Cells(2).Value = Record(r).Cluster
        Table.Cells(1, 1).Offset(rowNumber - 1, -1).Value = Record(r).Cluster
        rowNumber = rowNumber + 1
    Next r
    Table.Offset(0, -1).Resize(Table.Rows.Count, Table.Columns.Count + 1).Sort key1:=Table.Offset(0, -1).Cells(1, 1), Header:=xlYes

    'Print Centroids - Headings

Hi Kaper, i´m so sorry,, you are right, there is nothing wrong with the chart I uploaded.. that is because in my tired, brain dead weakend state i uploaded the wrong WB. This has now been rectified.

Many thanks for taking the time to respond, much appreciated.