Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Good afternoon,
I was asked 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
URGENT help!!! chart size! Thank you! | Charts and Charting in Excel | |||
Timeline Chart? | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |