Feb 19 2020 03:39 AM
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)
Feb 19 2020 04:19 AM