I was asked to produce a chart displaying outstanding staff appraisals for 4
regional offices. The data used is 'sales', 'admin' and '%age of total
staff', (the total staff being those employed in that region) . I managed to
produce a chart showing 4 sets of 3 columns, a nice colour scheme, separate
sheets generated for each month, etc.

Now I've been asked to include a 'reference' column which just shows the
total staff for all 4 offices. This sounded simple but hasn't turned out
that way.

I have produced another data series and selected a single cell as the data
source but while this displays on the chart, Excel assumes I want it shown
with the first set of data and that I also want a blank column on each of
data sets 2-4. What I really want is for this column to be separate from the
others and shown on the left.

Any help appreciated would be appreciated. Even being told it isn't possible
would be a step forward.