A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Displaying single and multiple data series.Single data series



 
 
Thread Tools Display Modes
  #1  
Old January 29th, 2006, 07:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Displaying single and multiple data series.Single data series

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.


  #2  
Old January 30th, 2006, 03:36 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Displaying single and multiple data series.Single data series

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
http://PeltierTech.com/
_______

"Donald Macleod" wrote in message
o.uk...
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.



  #3  
Old January 30th, 2006, 03:52 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Displaying single and multiple data series.Single data series

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
http://PeltierTech.com/
_______

"Jon Peltier" wrote in message
...
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
http://PeltierTech.com/
_______

"Donald Macleod" wrote in message
o.uk...
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.





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple sheets as data for a single sheet Newbie1092 Worksheet Functions 1 December 19th, 2005 06:20 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting 12 December 19th, 2005 06:00 PM
strategy for data entry in multiple tables LAF Using Forms 18 April 25th, 2005 04:04 AM
Problem combining data from multiple rows into a single row Frank Kabel Worksheet Functions 0 April 8th, 2004 08:29 AM
Multiple Charts from single instance of data dvt Charts and Charting 1 September 21st, 2003 01:45 PM


All times are GMT +1. The time now is 11:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.