EDIT - Ignore this, i need to re-think it because i'm limiting a scatter chart to only 5 data points, it doesn't actually show the concentration like i'd intended. Need to rethink this.
I'm 99% sure what i want to do is use a scatter chart but can't get my brain to focus on how to display it.
I've got a list of customers and they're grouped into 20 categories.
Ranking A-D for Revenue
Ranking A-E for Margin
These are then combined so the ideal world is AA, then AB, all the way down to DE.
The way i've managed to get it to work is to convert each letter to a number so A=1, etc
Then do a scatter chart that plots it out. So using the graph below i can show that this particular office has a concentration of clients around the bottom right corner (This is a very small sample)
What i could do with doing is having Excel show the axis with A - D rather than 1 - 5
Is that possible?
I'm 99% sure what i want to do is use a scatter chart but can't get my brain to focus on how to display it.
I've got a list of customers and they're grouped into 20 categories.
Ranking A-D for Revenue
Ranking A-E for Margin
These are then combined so the ideal world is AA, then AB, all the way down to DE.
The way i've managed to get it to work is to convert each letter to a number so A=1, etc
Then do a scatter chart that plots it out. So using the graph below i can show that this particular office has a concentration of clients around the bottom right corner (This is a very small sample)
What i could do with doing is having Excel show the axis with A - D rather than 1 - 5
Is that possible?
Last edited: