problems creating a diagram in excel

Copper Contributor

I have a problem creating a diagram in excel.

 

I have a competitor analysis - so the 20 competitors are my labels

 

For each of the 20 competitors I have two values. Price and quantity.

 

I want to show price on y axis and quantity on x axis and then I want the dots (dot diagram) to be the company and be a set op variables (combined price and quantity for that company).

 

The result should be 20 dots (competitors) showing which ones have high/low price combined with high/low quality) 

1 Reply
Sounds like you need to insert a scatter chart. Highlight both columns of data and then make one from the Insert tab.