Custom Bar Chart....strange question

**Trick** · 11-07-2006, 09:06 AM

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...

**Bryan Hessey** · 11-07-2006, 08:03 PM

Originally Posted by Trick

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...

The attached should help, the figures at D5:H5 would need to be your breakdown of 'other' by territory.

hth
---

added,

you might like to remove 'Major Gridlines' and set Data Labels = Value for the major Data Series.