Hi,
I have plotted a 2 x 2 according to the instructions here:
How to Create a Static Four Quadrant - Matrix Model in an Excel Chart | Critical to Success
...but I'm encountering some problems:
1) Not all of the labels are showing up for all of the dots on the map - any idea why this is happening and how to fix it?
2) The labels overlap (I used the standard 'bottom' selection for label placement) - any idea how to tell Excel to not let those boxes overlap?
3) The colors for the boxes are all the same or automatically assigned random colors - is there a way for me to assign color based on a group that I assign the point to?
4) Could I normalize the size of the dots? They are all plotted based on scores between 2 and 4.5 but I don't think the contrast is stark enough - is it possible to normalize the size of the balls to get a better contrast between the sizes? I have done it logarithmic but that was too stark.
Thanks for any help!
Daniel
I have plotted a 2 x 2 according to the instructions here:
How to Create a Static Four Quadrant - Matrix Model in an Excel Chart | Critical to Success
...but I'm encountering some problems:
1) Not all of the labels are showing up for all of the dots on the map - any idea why this is happening and how to fix it?
2) The labels overlap (I used the standard 'bottom' selection for label placement) - any idea how to tell Excel to not let those boxes overlap?
3) The colors for the boxes are all the same or automatically assigned random colors - is there a way for me to assign color based on a group that I assign the point to?
4) Could I normalize the size of the dots? They are all plotted based on scores between 2 and 4.5 but I don't think the contrast is stark enough - is it possible to normalize the size of the balls to get a better contrast between the sizes? I have done it logarithmic but that was too stark.
Thanks for any help!
Daniel
