Help/Ideas plotting intersecting points on chart

[mrp03]

Hi

I have a table, basically a list of customers and each has 2 distinct data values. Im trying to find a way to chart/pivot chart each customer at the intersection point of those 2 values.

I've attached a sample example, hopefully I posted that correctly (first post), that shows a couple of sample rows of data, how Ive been able to get excel to chart it and a mock up of how I'd like to chart it.

If the attachment does not post correctly, essentially

Customer Name Product Count Sat Score
Acme Widgets 4 3
Beta Widgets 2 5

Trying to get a chart where Sat Score is on the X axis (scale 1-5) and Product Count is on the Y axis (1-5) and and Acme Widgets would show one point intersecting at 3,4

Is there a way either charting directly or using pivot/picot chart to accomplish this. My original list has a few hundred rows so trying to avoid plotting by hand...

Thanks in advance

[MrShorty]

I feel like there is more to the question than I am seeing. The short, easy answer based solely on the small example is to edit each data series to use the correct X and Y ranges for each data series:

1) Bring up the Select Data dialog.
2) Select the "Acme" data series and edit the data series.
3) Tell Excel to use C2 for the Y values and D2 for the X values.
4) Select the "Beta" data series and edit the data series to use C3 for the Y values and D3 for the X values.
5) As tedious as it is, repeat for each data series in the chart.

If I wanted to avoid the tedium of editing multiple data series, I might approach this scatter chart like this:

1) Rearrange source data so that Sat Score is in column C and Product Count is in column D. (Excel expects to see the X values in the left column when creating a chart).
2) Select C2:Dn and insert a scatter chart.
3) Select the data series and add data labels. Format the data labels to use "values from cells" and use B2:Bn for the data label values.
4) Edit the text in column B to minimize the amount of text displayed in the chart, if needed.

If you really want a separate data series for each customer, then a pivot table may be able to help with rearranging the data, but you will need to be aware that a pivot chart cannot be an XY scatter chart. This could mean needing to be extra careful when creating the chart so that you don't inadvertently make a pivot chart (https://peltiertech.com/regular-char...-pivot-tables/ ).

1) Select the database and insert a pivot table. Tell Excel to use Sat score as the row labels, Customer as the column labels, and Sum of Product count as the pivot values.
2) Follow Peltier's instructions for creating a regular chart from pivot data, using the Sat score column as the X values and the Customer columns as Y values.

A lot will depend on exactly how you are using and interacting with the spreadsheet/chart.

[mrp03]

Thank you

No, nothing more to the question. It was the simplest example I could think of to illustrate what I was trying to do without including sensitive/personal data.

I was able to use the second set of steps provided and tweak it a bit to get what I was looking for.

Thanks again for the quick help/direction.