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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Urgent Chart Questions



 
 
Thread Tools Display Modes
  #1  
Old May 9th, 2005, 11:01 PM
Brent E
external usenet poster
 
Posts: n/a
Default Urgent Chart Questions

Good afternoon,

I was askes to produce some charts this afternoon for our marketing team and
I am trying to make a pic chart and bar chart for comparison based on the
following example data.

Office Names: Listings Sold Volume
COMPANY A 34
COMPANY B 408
COMPANY C 321
COMPANY D 200

I've got a couple questions.

* Regarding a bar chart: I want to produce a bar chart that shows these
values (1 bar each) and some space between them. What I've been doing is to
select the four cells of data that contain these listing stats and then I
goto Chart menu | Insert Chart | I select a bar chart and then click finish.
The first bar chart option creates a bar chart w/ different bars and colors
for data, but no space in between. The rest of options pile the data on top
of each other into 1 long column or bar. Niether of these are what I want. If
I go in and try to add a few series manually, doesn't seem to make any
difference. What do I need to do to create a 3-D bar chart that uses seperate
bars for data and spaces them apart?

* Regarding pie charts. If I try to make a pie chart out of the same data, I
find this chart automatically converts the values into a percentage of the
whole. I would like a pic chart that shows the actaul values of each slice
(not percentage) for each company. What do I do to do this? I also saw a post
where somebody suggested using secondary axis names to label pie units. I
would like to do this but when I go into my chart options, only my Chart
Title, X-axis title and Y-axis titles are availabe to me, my secondary title
boxes are greyed out. Why is this? Thanks.

Cordially,


 




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
Scale tab missing on chart format button. Urgent! MusicMonkey Charts and Charting 1 October 5th, 2004 02:54 AM
build chart template; then add series one by one L Mehl Charts and Charting 2 February 12th, 2004 11:53 PM
Pivot Chart affected when refresh data Ailing Charts and Charting 1 January 15th, 2004 12:20 PM
Printing Text Boxes with a chart Jon Peltier Charts and Charting 1 January 12th, 2004 02:51 PM
accessing chart objects via VB CycleMark Charts and Charting 1 October 27th, 2003 05:52 PM


All times are GMT +1. The time now is 12:57 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.