Hello

attached is my graph im working on.

there are two graphs.

1)one is a clustered side by side graph showing the $ dolar value

2)100% clustered side by side...where my target is my projected revenue aka 72800$

.....i believe its been done correctly, if one of your gurus can kindly have a look and let me know.

more importantly,

if someone can help me with the graph first (grey color), as i cant get the legend to show the person's name aka cell C9

also, for my second graoh (blue and red color....100% clustered), how can i get the value to show up? i would like the dollar value to show instead of the percentage?

can someone pls help me with this, been struggling for the past day +. thx you, much appreciated!!!

attached is my graph im working on.

there are two graphs.

1)one is a clustered side by side graph showing the $ dolar value

2)100% clustered side by side...where my target is my projected revenue aka 72800$

.....i believe its been done correctly, if one of your gurus can kindly have a look and let me know.

more importantly,

if someone can help me with the graph first (grey color), as i cant get the legend to show the person's name aka cell C9

also, for my second graoh (blue and red color....100% clustered), how can i get the value to show up? i would like the dollar value to show instead of the percentage?

can someone pls help me with this, been struggling for the past day +. thx you, much appreciated!!!

- Can I make a graph with side-by-side pie charts?
- Side by Side Bar Graphs? *urgent*
- Graphing-Two stacked columns side-by-side per year
- Can I use side by side colums and stacked columns in same graph?
- Side by Side Bar Graphs? *urgent*
- Creating stacked graphs side-by-side
- Graphing-Two stacked columns side-by-side per year
- Side by side stacked bar chart
- Create stacked bar graphs
- Stacked Bar Graph Question
- Combining multiple separate columns into one Stacked Bar Graph
- Putting Y-Axis values on both sides of the Excel bar Graph
- Stacked Chart - Side By Side
- How do I chart two stack columns side by side?
- Combining 2 different types of bar graph
- Bar graph (Excel '03), can I show percentages within a bar?
- Drawing bell graphs side-by-side
- How do i build a stacked bar graph with three variables?
- How do I format the data labels in my stacked bar graph?
- Create bar graph with two series and secondary y axis
- Data markers in a stacked chart will not sit side by side by month
- Stacked Bar Graph with Average Line
- How do I make a chart with bar graphs on one axis, and a line ona secondary axis?
- Creating two bar graphs

charts out of each of them and show them side by side. Can i do this? I have

Excel 200.

statistics class. Prof wants us to summarize some data about an

incoming (college) class and present it in graphical form.

He wanted me to do, among other things, a graph which shows the average

distribution of SAT scores (Math & Verbal) side by side (Same Y axis, X

Axis repeating). He showed me how to do it, but I lost my notes. The

data is grouped into bins of 100.

Can anyone help?

--

VBTahoe

------------------------------------------------------------------------

VBTahoe's Profile: http://www.excelforum.com/member.php...o&userid=31980

View this thread: http://www.excelforum.com/showthread...hreadid=517089

along the x-axis, and 'Dollars' is on the y-axis. There are two sets of data

(with three dollar amounts)for each year. The first is for the corporation

overall, and the second is for one business unit within the corporation. I

want to display two stacked columns side-by-side within each fiscal year. How

do I do this?

Excel keeps trying to stack the six into one column per fiscal year. Here

is a depiction of what I am trying to do:

A X A X A X A X

B Y B Y B Y B Y

C Z C Y C Y C Y

Year 1 Year 2 Year 3 Year 4

ABC is the stacked data for the corporation. And XYZ is the stacked data

for one of the business units within the corporation.

would like to add a stacked column to the graph without losing the other side

by side columns.

He wanted me to do, among other things, a graph which shows the average distribution of SAT scores (Math & Verbal) side by side (Same Y axis, X Axis repeating). He showed me how to do it, but I lost my notes. The data is grouped into bins of 100.

Can anyone help?

July

Metal Glass Water

Control 2 1 3

Breaker 4 1 1

Softstarter 5 2 1

August

Metal Glass Water

Control 1 3 2

Breaker 2 3 3

Softstarter 1 4 2

along the x-axis, and 'Dollars' is on the y-axis. There are two sets of data

(with three dollar amounts)for each year. The first is for the corporation

overall, and the second is for one business unit within the corporation. I

want to display two stacked columns side-by-side within each fiscal year. How

do I do this?

Excel keeps trying to stack the six into one column per fiscal year. Here

is a depiction of what I am trying to do:

A X A X A X A X

B Y B Y B Y B Y

C Z C Y C Y C Y

Year 1 Year 2 Year 3 Year 4

ABC is the stacked data for the corporation. And XYZ is the stacked data

for one of the business units within the corporation.

periods? For example, I want to compare quarterly profits for the years 2004

and 2005. I am using MS Excel 2003.

CODECanada Dollar Canada Total Dollar STATUSUS Percentage of ABCCAN Percentage of ABCA $ 0.08 A0%B $28,496,868.56 $ 23,809,913.36 A97%95%B $ 923,344.97 $ 960,079.67 D3%5%B $ 7,152.07 $ 532.31 I0%0%C $34,174,852.75 $ 8,300,191.88 A99%100%C $ 142,452.74 $ 1,791.91 D0%0%C $ 140,612.00 $ - I0%0%H $ 5,413,272.28 $ 1,970,971.44 A96%98%H $ 85,317.79 $ 1,116,178.87 D4%2%H $ 57.45 $ - I0%0%O $ 38,529.75 $ 2,781.33 A10%9%O $ 251,052.75 $ 10,819.99 D88%35%O $ 17,798.31 $ 17,760.46 I3%57%P $ 8,052,135.94 $ 96,287.56 A81%95%P $ 838,144.35 $ 5,260.54 D18%5%P $ 3,504.08 $ - I0%0%S $1,415,721.14 $ 8,520,630.26 A90%80%S $ 13,135,314.37 $ 1,529,398.17 D9%17%S $ 394,185.71 $ 1,396,492.92 I1%3%T $ 734,640.88 $ 134,007.89 A96%100%T $ 29,516.66 $ - D4%0%U $ 3,173,544.91 $ 8,400,725.03 A60%35%U $ 2,081,437.00 $ 7,515,658.82 D39%63%U $ 68,004.60 $ 59,100.63 I1%1%V $ 67,671.26 $ 7,177.71 A16%33%V $ 365,842.13 $ 63,398.06 D84%62%V $ 738.37 $ 1,168.92 I0%5%X $ 222,297.21 $ - A45%0%X $ 266,914.04 $ 93,503.91 D55%99%X $ 461.93 $ 387.29 I0%1%

works, but I decided I wanted them color coded by party so there will have to

be multiple series on one Stacked Bar Graph. However whenever I attempt this

the series do not stack properly.

For Example I want Series 2 (Durations of Terms for Party A) stacked on

Series 1 (Years of Inaugurations for Party A.) Then I want Series 4 (Duration

of term for Party B) stacked on of Series 3 (Years of Inaugurations for Party

B.) But when I attempt to graph it either stacks series 1, 2, and 3 together

or botches it some other way. Can anyone help me sort out the stacking?

I have created a Bar graph in excel with percentage values on the left y-axis.

I want to add the the number values to other y-axis side so that it can be well understood by the reader.

Any one knows how to put the y-axis values on both sides of the graph?

Much appreciation

Does anyone know if there is a way to get a stacked chart side by side? For

example, you have airplanes, cars and trains on the x axis and values of

2005, 2006, 2007 and 2008. I know you can have all these values in one bar

but is it possible to have two stacked bars for one x-value? For example,

for airplanes, you have one bar with 2005 and 2006 and a bar next to it with

the 2007 and 2008 values.

Thanks, appreciate your help.

So essentially I want two stacked charts to show up side by side for each month, but I can't figure out how to do this.

Any help would be greatly appreciated.

Thanks!

I have 3 series of sales data I need to plot - actual, max budget & min

budget - for 12 months.

With the months being the x axis, I need the graph to be a standard bar

chart, with the colums side by side for each month (clustered column).

However, for the 2 bdget columns I need them to be of the "stacked" column

type - so that when the graph is presented we can see exactly how the actual

column each month compares to both budget figures.

I've tried changing the chart type for each of the series, but it seems to

change all 3 series each time. I could easily combine a line graph with the

stacked columns, but for some reason I can't combine stacked columns and

clustered columns.

I hope I've explained this well!!

Thanks in advance

Dave

1. Number of items inspected

2. Percentage of items that passed inspection

3. Percentage of items that failed inspection

My boss would like to see a bar graph that shows the percentage of items inspected as the bar (use 75% as an example), but within that bar he would like for me to be able to display the pass/fail percentages.

When I use a stacked bar it shows all 3 values on top of each other and it goes up above 100%. But I need it to show the bar at 75%, and then that bar to be colored say 80% green (for passed inspection), and 20% red for failed.

I have to do this for various vendors, so that is why they would like everything displayed in one bar.

FYI, I have created a graph that shows the percentage passed vs. percentage failed as the bar then did a line graph as a secondary value over it to show the percentage that were inspected........but they want the percentage inspected as the main thing you see. (I attached a sample below of what I created).

sample.jpg

Thanks for your help!

drawing.

i was able to draw two different bell graphs following the help provided

earlier, but still cannot draw them together with some overlapping tails.

perhaps, the difficulty i have is "selecting" the columns (range?) . i

"selected" all four columns (two columns for taller graph, and the other two

columns for shorter graph), but it draws a linear graph.

any help is appreciated.

variable and the components of it.

I am trying to make the Data Labels fit withing the stacked bar graph,

but cannot seem to have any success. I want each label to distribute

itself evenly within the boundries of bar it is labeling. I know that I

can use text box over each bar, but that is a lengthy process and is hit

or miss for me.

Does anyone have any ideas?

Thanks!!!

--

ocjred

------------------------------------------------------------------------

ocjred's Profile: http://www.excelforum.com/member.php...o&userid=37022

View this thread: http://www.excelforum.com/showthread...hreadid=567447

bars as well as having a secondary Y axis. The bar graph looks fine

untill I try and put on a secondary Y axis- then it overlays the bars

on top of each other ( one bar becomes masked by the other). It wont

keep them side by side.

Appreciate any suggestions

cheers

--

macmullet

------------------------------------------------------------------------

macmullet's Profile: http://www.excelforum.com/member.php...o&userid=35032

View this thread: http://www.excelforum.com/showthread...hreadid=547755

stacked chart to sit side by side with a space before the next month (August

Actual & August Budget) and so on for each month.

Panther). I've currently got two charts: one is a bar graph with two groups,

and each bar has two colors (one for each of the groups) - 100% stacked

column. I have another graph which is a very simple line graph. Both graphs

have the same X axis (with 7 data points), but different Y axes. How do I

combine them into the same chart? I know how to make a secondary axis, and

the example in Excel (a "custom" chart) has a bar graph plus a line graph on

the secondary Y axis, but its bar graph is a simple bar graph, not the

stacked kind that I have, so it's not quite what I want. Can anyone help? I

can provide examples (PDF, but I know people don't like to download Usenet

messages with attachments...). Thanks in advance!

Mike

"x" access?

Any help is much appreciated.

Thanks!