Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Brent E
 
Posts: n/a
Default Urgent Chart Assistance

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,


  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Using the chart wizard select the data range and the clustered bar chart
type. On the 2nd step of the wizard select "Series in: Columns". this
should give you 4 bars all coloured the same with spacing.

On the pie chart the data labels has an option to display values instead
of percentages.

Cheers
Andy

Brent E wrote:
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,



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scrollbar on Chart Jumps to Left when Chart is Clicked Bob Charts and Charting in Excel 5 May 1st 05 02:06 AM
URGENT help!!! chart size! Thank you! crossingmind Charts and Charting in Excel 5 April 28th 05 05:24 PM
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 10:20 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 06:54 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 11:36 PM.

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

About Us

"It's about Microsoft Excel"