Forum Discussion

Jagob's avatar
Jagob
Copper Contributor
Feb 19, 2020

problems creating a diagram in excel

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) 

excel

1 Reply

  • Savia's avatar
    Savia
    Iron Contributor
    Feb 19, 2020
    Sounds like you need to insert a scatter chart. Highlight both columns of data and then make one from the Insert tab.

Resources