Need help creating a chart

[jfish1288]

I am not sure what to call the type of chart I want to create, which has made it very difficult to find any solutions via searches. I am hoping someone here can point me in the right direction.

I have data in the following format:

Book3
	A	B	C	D	E
22	Item	Type	Brand	Size	Price
23	Item1	Type_A	Brand 1	8	$499
24	Item2	Type_A	Brand 2	8	$99
25	Item3	Type_A	Brand 3	8	$99
26	Item4	Type_A	Brand 2	9	$99
27	Item5	Type_A	Brand 3	9	$199
28	Item6	Type_A	Brand 1	10	$599
29	Item7	Type_A	Brand 2	10	$99
30	Item8	Type_B	Brand 1	8	$499
31	Item9	Type_B	Brand 3	9	$299
32	Item10	Type_B	Brand 1	10	$599
33	Item11	Type C	Brand 1	8	$499
34	Item12	Type C	Brand 2	8	$299
35	Item13	Type_C	Brand 3	8	$399
36	Item14	Type_C	Brand 2	9	$299
37	Item15	Type_C	Brand 3	9	$499
38	Item16	Type_C	Brand 1	10	$599
39	Item17	Type_C	Brand 2	10	$299
40	Item18	Type_C	Brand 3	10	$599
Sheet1

And I would like to create a chart similar to the one I drew by hand below.
I want to plot all of the items by size (x-axis) and price (y-axis), and I want the x-axis grouped by type.
And it is important that I be able to identify the Item# by hovering or clicking on any particular point (I can't label all of the points because the graph will become illegible).

What would you call this type of chart? Can it be made in excel? Any other solutions? It doesn't seem much more complex than a standard scatterplot, but I cant figure it out.

 

[jfish1288]

The only pseudo solution I have found is to rearrange the data like below, and then create a separate chart for each type. But I have a few issues with this:

1. I cannot identify item# from the points
2. Creating and maintaining the multiple chats would be very cumbersome as I play with the different data sets I have
3. If 2 items share the same size, type, and price they cannot be identified

Book3
	A	B	C	D	E	F
1	Item	Type	Size	Brand 1	Brand 2	Brand 3
2	Item1	Type_A	8	$499
3	Item2	Type_A	8		$99
4	Item3	Type_A	8			$99
5	Item4	Type_A	9		$99
6	Item5	Type_A	9			$199
7	Item6	Type_A	10	$599
8	Item7	Type_A	10		$99
9	Item8	Type_B	8	$499
10	Item9	Type_B	9			$299
11	Item10	Type_B	10	$599
12	Item11	Type C	8	$499
13	Item12	Type C	8		$299
14	Item13	Type_C	8			$399
15	Item14	Type_C	9		$299
16	Item15	Type_C	9			$499
17	Item16	Type_C	10	$599
18	Item17	Type_C	10		$299
19	Item18	Type_C	10			$599
Sheet1