software

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.
Set up your data as shown below:
Sales Admin %Total Reference

Reference [data]

Office A [data] [data] [data]

Office B [data] [data] [data]

Office C [data] [data] [data]

Office D [data] [data] [data]
Select the entire range, and create a clustered column chart. Double click
on the Reference data point (the lonely column above the first category),
and on the Axis tab, select Secondary. Select Chart Options from the Chart
menu, and on the Axes tab, uncheck the Secondary Y Axis box.
Voila.- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;Donald Macleodquot; gt; wrote in message o.uk...
gt;I was asked to produce a chart displaying outstanding staff appraisals for
gt;4 regional offices. The data used is 'sales', 'admin' and '%age of total
gt;staff', (the total staff being those employed in that region) . I managed
gt;to produce a chart showing 4 sets of 3 columns, a nice colour scheme,
gt;separate sheets generated for each month, etc.
gt;
gt; Now I've been asked to include a 'reference' column which just shows the
gt; total staff for all 4 offices. This sounded simple but hasn't turned out
gt; that way.
gt;
gt; I have produced another data series and selected a single cell as the data
gt; source but while this displays on the chart, Excel assumes I want it shown
gt; with the first set of data and that I also want a blank column on each of
gt; data sets 2-4. What I really want is for this column to be separate from
gt; the others and shown on the left.
gt;
gt; Any help appreciated would be appreciated. Even being told it isn't
gt; possible would be a step forward.
gt;
The table didn't paste correctly from Notepad. Here's what the data should
look like:

Sales Admin %Total Reference
Reference [data]
Office A [data] [data] [data]
Office B [data] [data] [data]
Office C [data] [data] [data]
Office D [data] [data] [data]

Top left cell must be blank, completely clear.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;Jon Peltierquot; gt; wrote in message
...
gt; Set up your data as shown below:
gt;
gt;
gt;
gt; Sales Admin %Total Reference
gt;
gt; Reference [data]
gt;
gt; Office A [data] [data] [data]
gt;
gt; Office B [data] [data] [data]
gt;
gt; Office C [data] [data] [data]
gt;
gt; Office D [data] [data] [data]
gt;
gt;
gt;
gt; Select the entire range, and create a clustered column chart. Double click
gt; on the Reference data point (the lonely column above the first category),
gt; and on the Axis tab, select Secondary. Select Chart Options from the Chart
gt; menu, and on the Axes tab, uncheck the Secondary Y Axis box.
gt;
gt;
gt;
gt; Voila.
gt;
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Donald Macleodquot; gt; wrote in message
gt; o.uk...
gt;gt;I was asked to produce a chart displaying outstanding staff appraisals for
gt;gt;4 regional offices. The data used is 'sales', 'admin' and '%age of total
gt;gt;staff', (the total staff being those employed in that region) . I managed
gt;gt;to produce a chart showing 4 sets of 3 columns, a nice colour scheme,
gt;gt;separate sheets generated for each month, etc.
gt;gt;
gt;gt; Now I've been asked to include a 'reference' column which just shows the
gt;gt; total staff for all 4 offices. This sounded simple but hasn't turned out
gt;gt; that way.
gt;gt;
gt;gt; I have produced another data series and selected a single cell as the
gt;gt; data source but while this displays on the chart, Excel assumes I want it
gt;gt; shown with the first set of data and that I also want a blank column on
gt;gt; each of data sets 2-4. What I really want is for this column to be
gt;gt; separate from the others and shown on the left.
gt;gt;
gt;gt; Any help appreciated would be appreciated. Even being told it isn't
gt;gt; possible would be a step forward.
gt;gt;
gt;
gt;