Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Stacked Bar Chart with Secondary Axis

Need to create a stacked bar chart and utilize the secondary axis for data
with a different value range.

Data Table:
Yr 1 YR 2 Pipeline
Small Deals 7 1 13
Med Deals 2 6 14
Large Deals 0 2 20

Primary axis should be Yr 1 & 2 and secondary axis should be pipeline.
Having created the stacked bar chart I change the pipeline series to the
secondary axis and end up with a simple bar chart. How can I create a
stacked bar chart with a secondary axis with a different scale?

Thanks.


Post your answer or comment

comments powered by Disqus
Need to create a stacked bar chart and utilize the secondary axis for data
with a different value range.

Data Table:
Yr 1 YR 2 Pipeline
Small Deals 7 1 13
Med Deals 2 6 14
Large Deals 0 2 20

Primary axis should be Yr 1 & 2 and secondary axis should be pipeline.
Having created the stacked bar chart I change the pipeline series to the
secondary axis and end up with a simple bar chart. How can I create a
stacked bar chart with a secondary axis with a different scale?

Thanks.

I'm looking to create a stacked bar chart with primary axis and secondary axis side by side, with my primary values (percentages) to the right of zero and secondary values (currency) to the left of zero. I almost want a Positive-Negative/Tornado chart but I want to be able to graph two different variables/number formats on the X-axis adjacent to each other.

I'm trying to create a stacked column chart, but with column D requests on the secondary axis.

I used a tutorial on-line to create a stacked column chart with the total displayed above the bar, but it seems in 2007 I can't get even this to display the data label above the bar.

http://www.ozgrid.com/Excel/stacked-column.htm

What am I missing here?

I am using stacked bar charts to show the various stages a patient goes through in their visit to the Doctor's office. Each stacked bar represents one patient. Most of the stages all follow in a linear sequence, but a few key points do not. For those, I am trying to add markers using line charts. So, there are the stages that follow one another, each with the time value for that particular patient, one stacked on the other, and then there are the markers indicating where the non-linear events occurred.

I add the non-linear events, such as when the MD walks into the exam room, as another series but change that series to a line chart instead of a bar chart, and take out the "line" but leave the marker.

I end up with stacked bars showing how long each patient waited at each stage, and a marker where the MD intervened (sometimes they come out to the waiting area, sometimes they see the patient early in their exam room, sometimes the patient waits in the exam room a long time before the MD enters --- the marker for the MD can fall anywhere on the stack).

The problem I am having is turning this sideways so that you can follow the stages left to right. You can select a sideways stacked bar chart, and that does show the stages for each patient from left to right. But it does not appear that excel allows you to do the same with the line chart series. Changing the chart type to a side-ways stacked bar only works for the bars, and not the line. So, you end up with line markers that are not related to the same axis as the stacked bars, and Excel now adds a second axis when you try to do this.

Is there a way to have both a sideways stacked bar chart with a line chart that also runs sideways on the same axis?

Hi, I need help with a stacked bar chart with negative figures.

I can't give you specific details on what it's for, but the scenario is something like this

We are given a budget to work around. Thus, we allocated the budget around as we saw fit.(Hypothetically, let's say category 1 uses $1000, category 2 uses $2000, and category 3 uses $3000).

However, we found out we used more in some areas, and less in others (Hypothetically, category 1 uses $1250, category 2 uses $1500, and category 3 uses $3500).

My boss wants me to find out the discrpency between the amount originally planned and the amount that is actually been used, broken down for each individual section (Which mean that, hypothetically, category 1 has +$250, category 2 has -$500, and category 3 has +$500).

Now, he wants me to combine all the data into a single chart. For those with purely positive numbers, it is easy enough, but for those with negative numbers, the graph didn't work out how I imagined it to be.

My plan was to put the original planned amount and the discrepency in the primary axis and the actual amount used in the secondary axis(with an invisible fill but a thick border to indicate the amount actually used). Thus, if the actual amount is more than the planned amount, it would appear such that the border envelops both the planned amount and the discrepency, but if the actual amount is less than the planned amount, the border would only cover a portion of the planned amount, with the discrepency being tacked on where the border left off.

Is there any way to create the chart in the way that I had imagined? If not, is there a system that could give me the same effect? I tried looking at a waterfall chart, but it appears that I need a lot of graphs, one for each different category, and my boss does not want that.

Any help would be appreciated. Thanks.

Also, I apologise if this section is not where I should post ths question.

Hi – I am trying to chart two data series in a bar chart with two axis. I want the bars to be adjacent to each other, not stacked one on top of the other.I have tried editing the gap overlaps but this does not seem to help. Any ideas?

Hi folks

I’m using Excel 2003 and I’m trying to generate a combined HORIZONTAL stacked bar chart with a scatter chart.

I have been able to do this with a VERTICAL stacked bar chart with a scatter chart (thanks to Andy Pope - took his idea from another post and used it) but Excel states some chart types cannot be combined with other chart types and am unable to create the horizontal version I need.

The data below should be First, Second and Third "quartiles" in a 0 to 100 scale horizontal stacked bar chart with the Previous and Current values (possibly using a secondary 0 to 100 scale) as a scatter chart on the relevant stacked bar

First Second Third Previous Current
A 76.5 80 83.5 50 85.7
B 77.5 99 120.5 19.8 48.8
C 55.75 62.5 69.25 77.8 96.3

Does anyone know of a solution, even if it means using a macro and VBA to generate the chart?

Here's hopeing someone out there can help ...

NoCanDo

I want to have a stacked bar chart, with 3 bars aranged into monthly groups.
So if I produced a yearly graph, it would contain 36 bars in total.
Im using excel 2002 (xp) and can get either a stacked bar chart, or a
grouped bar chart, but not both together.

Need a stacked bar chart with each section of the stack representing a month,
but some of the months have a negative number. The chart moves the negative
number to the bottom of the graph, when I need it to show in monthly order.

Any help on this would be great!

How can I create a double stacked bar chart w/ a secondary Y-axis line chart?
I've read and understand the "Column Chart with a Difference" example he
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm. But, need to go the
step further, to have a % displayed on the secondary Y axis.

Hi All,

I have made a stacked bar chart with a nested category axis (x-axis). For each main category there are 2 subcategories. eg Stage1 Project1 and Project2, Stage2 Project1 and Project2, etc.

The bar for each Project is a stack of 2 costs: primary cost and secondary cost.

I would like to put my projects on the z-axis, maintain my stages on the x-axis and keep my stacking.

Any thoughts?

Thanks,

Jen

I want to plot # of deliveries and $ by quarter. The # of deliveries needs
to be on the y-axis and the $ need to be on the secondary y-axis. Both
series have the same x-axis data (quarter). I need to have them show up as
bar charts with a gap between range data.

Every time I do it, it just sets one set of data on top of the other.

Is there a better way??

Hi all,

I'm working with one bar chart with two sets of data. I've set up a secondary value axis, and now all I need to do is get the bars next to each other instead of overlapping each other. I've attached my example.

Any help is much appreciated!

I'm using a stacked bar chart to track the harvest time of various fruit trees in a Gantt style setup. The vertical axis has the names of the different fruit varieties, and the horizontal axis has 1-unit progression starting with the first day of harvest to the last day of harvest. What I'd like to do is on the right vertical axis, have the actual production quantity for each variety. Is this possible?

hi folks
Apologies for this but I am absolutely stumped. I have some simple data and i want to create a horisizontal bar chart with 2 axis (X axis) the top one showing number of stocks number up to 270 and the bottom with Market Cap up to 1,200. (See attached)

I set up the chart and it looks fine but it has only one axis so in order to create a second axis i right click on the blue series (no of Stocks) and go through the motions of setting up a secondary axis. However when i do that it ends up looking like the chart to the right with the Bars Cojoined (which is not what i want) I cannot seem to achieve 2 axis with separated bars.

Sorry about the long explanation but this one has me exasperated..!

Cheers
James

Hi

I need to create a chart which would resemble a
variable width variable height stacked bar chart with
values on both sides of the Y axis (This I achieved by
giving values needed on the left a negative sign). I
tried to get the above chart using all these basic
charts in excel - stacked bar charts, stacked column
charts,stacked area charts, stacked scatter plots but
could not get the final chart. Though I was able to
get a variable height stacked bar chart(with pos n neg
values), I am not able to get the final desired chart.
Please let me know how I can get the above mentioned
chart.

Thanks
Ambika Thiruvengadam

--
ambthiru
------------------------------------------------------------------------
ambthiru's Profile: http://www.hightechtalks.com/m746
View this thread: http://www.hightechtalks.com/t2334639

Dear All,

Thanks for reading my post.

I have a stacked bar chart with labels on the vertical axis left hand side.

There are 40 labels, which are names.

I would like to Highlight some of the labels in a different color.

Can this be done?

Regards and thanks for your help Hohn.

Hi

I need to create a chart which would resemble a
variable width variable height stacked bar chart with
values on both sides of the Y axis (This I achieved by
giving values needed on the left a negative sign). I
tried to get the above chart using all these basic
charts in excel - stacked bar charts, stacked column
charts,stacked area charts, stacked scatter plots but
could not get the final chart. Though I was able to
get a variable height stacked bar chart(with pos n neg
values), I am not able to get the final desired chart.
Please let me know how I can get the above mentioned
chart.

Thanks
Ambika Thiruvengadam

--
ambthiru
------------------------------------------------------------------------
ambthiru's Profile: http://www.hightechtalks.com/m746
View this thread: http://www.hightechtalks.com/t2334639

Hi,

I am having some problems creating a graph as I would like to do. My data is below. (EDIT: or go here for easier viewing http://imgur.com/SMDL6)

Start Date End Date Completed Remaining Total
Milestone 1 17/10/2011 14/11/2011 3 11 14
Milestone 2 14/11/2011 28/11/2011 0 7 7
Milestone 3 28/11/2011 12/12/2011 0 7 7
Milestone 4 12/12/2011 16/12/2011 0 5 5

What I want to do is create a stacked bar chart, with a bar for each milestone, whose size and position is dependant on the start and finish dates (plotted on the x, or bottom, axis), with each bar coloured in to represent what percentage of tasks have been completed. So a milestone with exactly half of the tasks complete would be half red, and half blue.

http://office.microsoft.com/en-us/ex...001034605.aspx

Much like the graph seen on this page, but without the assumption that each task takes exactly one day, we don't know how long each task will take, we just want to know what percentage of a milestone needs completing, and how long we have to do it.

I can't find a way to do this! If anyone could help that would be a life saver!

Thanks, Jack

I am trying to create a 3 dimensional stacked bar chart with an added dimension showing depth. I have attached a graphical example as I cannot work out how to do this using a chart. Any help would be greatly appreciated

Here is my scenario, I have the following data:
Data Series 1
a=3
b=3
c=4
Tot 10

Data Series 2
d=2
e=2
f=2
g=1
h=1
i=1
j=1
Total 10

Data series 3
k=4 (d+e)
l=3 (f+g)
m=2 (h+i)
n=1 (j)

I want the three stack bars together, for the series 2 & 3 I want them without any gap so I can see how data series 3 is created.

I can't find a way to create a three stack bars chart that don't have the same number of data series, I don't want percentages.

I am using Excel 2003 Any idea?

Thanks

I have a time series stacked bar chart that consists of three products.
I would like the labels for each product to show that product's
percentage of the total of the three products. How can I go about
accomplishing this? I've seen previous repsonses to similar posts that
recommend plotting the percentages, but I don't think that alone would
solve my problem. I would still like to show the trend of the three
products total, which wouldn't be available if I plot the percentages
only, as all bars would equal 100%. Thanks for any help provided.

--
name
------------------------------------------------------------------------
name's Profile: http://www.excelforum.com/member.php...o&userid=34115
View this thread: http://www.excelforum.com/showthread...hreadid=563325

I have a stacked bar chart with two values and I want to add the data label
of the combined value. I have only been able to add each individual number.
Any ideas of how to get the totals. I have the totals done in the
spreadsheet.

Any way to have a stacked bar chart to represent the total of value a and
value b. Then add a horizontal line displaying a third value?

"Jon Peltier" wrote:

> Brenda -
>
> Try some of the links I've posted he
>
> http://peltiertech.com/Excel/ChartsH...sterStack.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Brenda wrote:
>
>


No luck finding an answer? You could always try Google.