Modify data points on scatter graph

[tiffanylee422]

Is it possible to modify the data points on a scatter graph so that the size of the data point is relative to the number of items at that data point?

Here's what I'm trying to achieve...
I have price data for 4 separate retailers in a certain category (lets say batteries for example). Each retailer carries a different selection of batteries at varying price points. I want to see the price range for each retailer, the individual price points, and the number of items at each price. I've been using a scatter graph that looks something like this (see below). The problem is that I haven't been able to figure out a way to include the number of items at each price point. I'd like the size of the data point to be larger when a retailer has multiple items at a single price. Is there a way for that to happen without manually resizing each data point myself?

In the graph below, each retailer has a separate price ladder where I can see the Opening Price Point and Max price. However, retailer #1 has 5 items priced at $45, so I'd like the "X" at that data point to be 5 times larger. Similarly, Retailer #4 (green line) has a multiple items at the $89 price point, so I'd like the triangle at that point to be larger.

 

[Steve=True]

Hi,

have you considered a bubble chart?

be aware though that the size of the bubbles may not exactly represent the size change from what you have in your list.

Steve=True