I have a list of customers with YTD sales revenue.
I have this split in a number of ways (if i desire), eg. territory, market sector, period etc.
I have a bar chart showing the top 25 customers by revenue.
The remainder of the customers which i class as independents (>400 customers) I have as the 26th customer - therefore the bar stack is probably about as high as the no.1 customer.
Just been asked if i can produce this:
On one graph is it possible to explode that one stack into territory, whilst leaving the other bars as they are.
i.e. so that it takes that form of a stacked bar (total value is all the independents - but split into a territory as opposed to customer).
I dont think this is possible without producing two separate charts.
But thought id ask anyway...
Bookmarks