Stacked Chart With Double Columns

Oct 30, 2006

According to my provided data, draw a stacked chart with double columns, each bar includes four types of data(Internet, PBS,Branches and Mail-in/Fax-in) and the x-axis are 1Q06, 2Q06 and 3Q06 repectively. It is urgent,pls provide the template for me. Many Many to all of you.

ADVERTISEMENT

Stacked Columns Chart - Use Non-numerical Data In The Vertical Axis?

Jun 10, 2014

I would like to create a chart with stacked columns. Usually, the data on the Y-axis is some kind of numerical data, such as budget. I would like to have the Y-axis have non-numerical data (= nominal categories).

Example :
Take the following data :
category | productname
red berry
red carrot
green cabbage
green apple

The ouput format i want is a chart which shows on the horizontal axis the categories red and green, and stacks in each category the right productnames on top of eachother; preferably each productname should have a different colour and showing data labels (e.g. "1", "green","apple" could be 1 specific data label).

I don't know how to achieve this, because if you display data as "count of productnames", then automatically you get something like a block with value 2, which doesn't show the different productnames inside that block.

Can the desired chart be made with Excel somehow?

View 6 Replies View Related

Columns & Stacked Columns Chart

Dec 12, 2006

I am trying to get an Excel chart to include columns AND stacked columns in the same chart with no success. I have attached the Excel chart where I could only get stacked columns and I had to use a line chart for the secondary axis. I could not figure out how to get the secondary axis to be a set as a column just like the primary axis. I thought this could be done in Excel, I have searched the forums and tried to play around with the gap width and/or include a blank column but I still haven't been able to get this to work.

View 5 Replies View Related

Overlay Line Chart On Top Of Stacked Column Chart?

Feb 15, 2012

I am trying to overlay a line chart on top of a stacked column chart. The stacked column chart is a chart where the x axis is dates and the y axis is amount. The line chart is a projected amount that I will reach in few years; the x axis is the date while the y axis is an amount. I can get a chart that has a line and stacked columns, but ever time, the dates get messed up. The line has an extremely wide date range while the columns only have about a month of data.

View 9 Replies View Related

How To Turn Bar Chart Into Stacked Chart

Feb 14, 2014

I have a two bar chart (red and blue) I'm trying to turn into a stacked chart. It has total cars and broken cars. There are a 100 total cars (10 broken). But when I stack them, it shows 110 total cars (it's adding instead of merging them). Once stacked, there should still be 100 total cars....but the tip of it should be red to show what amount is broken. It's adding the two together but it shouldn't....the number of broken cars is still part of the total.

View 1 Replies View Related

Stacked Bar Chart

May 22, 2006

I am trying to define a chart of TWO Stacked Bars. (it will be a little difficult for me, with my bad English, to explain – but I'm sure you will understand. My target is a chart as shown in the embedded picture. Take a look at sheet1:

This is a 75% completed chart. I managed to present the first 2 stacked bars. (light & dark green). Then I added a blank column ("D") and declared it as a "bar" on the 2nd. Y Axis. (This "D" series has now two values, of 5, which must be "Zeroed" when the chart is finished).

I managed to add the first part of the 2nd. Stacked bars. (Orange) I played a little with the Width and Overlap – and got the result shown in Sheet1. (When The "two fives" will change into 0 - the two orange bars will start from the X-Axis (Zero "Y" level)/ So far so good.

What I need now is to add the last Series (F2:F9) to be put ON TOP of the Orange Bar – but without success. If you'll take a look at Sheet2 you will see what I came up with. I DO NOT want them to be inside each other. I want them as in the embedded picture (side by side). In addition – I would love to present the Labels: Newspaper, Internet, Relevant, Non-Relv. Inside the chart (if possible)

View 2 Replies View Related

Two Stacked Bar Chart

Jul 13, 2006

I am trying to define a chart of TWO Stacked Bars. (it will be a little difficult for me, with my bad English, to explain – but I'm sure you will understand. My target is a chart as shown in the embedded picture. Take a look at sheet1:

This is a 75% completed chart.
I managed to present the first 2 stacked bars. (light & dark green).
Then I added a blank column ("D") and declared it as a "bar" on the 2nd. Y Axis.
(This "D" series has now two values, of 5, which must be "Zeroed" when the chart is finished).

I managed to add the first part of the 2nd. Stacked bars. (Orange)
I played a little with the Width and Overlap – and got the result shown in Sheet1.
(When The "two fives" will change into 0 - the two orange bars will start from the X-Axis (Zero "Y" level)/ So far so good.

What I need now is to add the last Series (F2:F9) to be put ON TOP of the Orange Bar – but without success. If you'll take a look at Sheet2 you will see what I came up with. I DO NOT want them to be inside each other. I want them as in the embedded picture (side by side). In addition – I would love to present the Labels:
Newspaper, Internet, Relevant, Non-Relv. Inside the chart (if possible)

View 2 Replies View Related

Stacked Area Chart In VBA

Oct 28, 2013

Code:
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlAreaStacked

I created a simple stacked area type in vba. Is it possible and how to have this stacked area to get values from combobox and textbox?

View 3 Replies View Related

Dynamic Stacked Bar Chart

Apr 28, 2006

I am trying to develop a dynamic stacked bar chart, I have a consistent number of columns defining the x axis and a variable number of rows defining the y axis (the stacked data). Is it possible to generate a dynamic stacked chart. I have tried using dynamic named ranges but I can't get it to work for a stacked chart.

View 7 Replies View Related

Stacked Bar/Column Chart

Oct 22, 2006

i have a chart made but it will only read numbers what i looking for it to do is read cells filled. beacuse none of the cells will have numbers in them. example column I,J,K,L will have a letters in them. starting on row 2 on down till the end. what i'm looking for is if I2 has a letter in it it will read as one for the chart. and will ignore the other columns if K7 has a letter it will read as one and ignore the rest of the columns. this will go on till the end of the sheet. and all rows with nothing in them will be ignored. is this posable?

i think it is bacisly giving a value to a letter and having the chart inturpat that value as 1 and then adding them up. if posable i just thought of maybe the letter could be turned into a date to give an ongoing graph for the info. maybe thats the wisest thing to do to show what each day looks like. hmm i have to play around with it. just typing this out i think i figured a way to do it.

View 8 Replies View Related

Stacked Column Chart

Oct 23, 2007

I have a spreadsheet where I have some data. The data is divided into two parts we have part A that is a figure and then I have a A total which is a figure which part A cannot exceed and then what I would like to do is to create a Stacked Column Chart where I have an A total column where the maximum amount is the total A and where I would like to show how much A has utilized the A total.

View 5 Replies View Related

Conditionally Color Stacked Bar Chart

Oct 9, 2007

I would like to display 50 sequences, S_1 ..S_50, with stacked bars. Every sequence can contain 5 different events, E_1 .. E_5, in a random order. Every event has a certain duration, t. Lets say the first two sequences are as follows (duration time is in brackets)

S_1:
E_3(200), E_1(150), E_2(300), E_4(500), E_5(300)
S_2:
E_1(200), E_4(150), E_1(300), E_5(500), E_2(300), E_2(300)
...

How do I get Excel to display all Sequences in one graph as a function of time, with the bar-stack-color displaying the kind of event. So if E_3 would be red and E_1 blue we would see

S_1:
red, blue ...
S_2:
blue, ...

View 5 Replies View Related

Stacked Chart - 2 Labels On X-axis

Jan 10, 2012

Using the table, draw a stacked chart that has both the project name (A, B etc) and Month on the x-axis (below all the projects). the stacked chart should contain the count for cat1, cat2, cat3 and cat 4 for each project (in different but consistent numbers for each month).

I need this for a presentation today,

OctoberNovemberDecemberProject Cat. 1 Cat. 2Cat. 3Cat. 4Cat. 1 Cat. 2Cat. 3Cat. 4Cat. 1 Cat. 2Cat. 3Cat. 4A
00236111110001B
C
D
E
F
0012230182600425G
H
I
02114001602210J
K
L

View 2 Replies View Related

Exasperated With 2007 Stacked Bar Chart

Jul 8, 2009

I need to create a chart showing a timeline from 0 hours to 100 hours. In this timeline, there has to be 8 seperate segments - ie, phase 1, phase 2, phase 3, phase 4, phase 5, phase 6, phase 7, phase 8. Each phase takes a certain amount of hours (the number of hours of each phase is irrelevant for now!).

how to format this data and then how to display such a chart? I need the timeline along the X axis.

View 9 Replies View Related

Conditionally Color Stacked Bar Chart

Oct 10, 2007

I would like to display 50 sequences, S_1 ..S_50, with stacked bars. Every sequence can contain 5 different events, E_1 .. E_5, in a random order. Every event has a certain duration, t. Lets say the first two sequences are as follows (duration time is in breckets)

S_1:
E_3(200), E_1(150), E_2(300), E_4(500), E_5(300)
S_2:
E_1(200), E_4(150), E_1(300), E_5(500), E_2(300), E_2(300)
...
How do I get Excel to display all Sequences in one graph as a function of time, with the bar-stack-color displaying the kind of event. So if E_3 would be red and E_1 blue we would see
S_1:
red, blue ...
S_2:
blue, ...

View 4 Replies View Related

Create Stacked Bar Chart/Graph

May 29, 2008

I need to plot a stacked chart. I have attached a sample of it. I need to plot, category As X and subcategory and and its percentage as Y (stacked chart). In the attached sample I plotted a chart. The problem is, the series name showing is not correct. It takes the series name from the top row.

View 5 Replies View Related

Power Pivot Chart With Stacked Column

Jul 30, 2014

I have created a Power Pivot Chart with Stacked Column chart. Made one axis as Secondary Axis and the axis is Clustered Column, but it is overlapped with Stacked bars.

Is there any easy way to solve this issue, apart from creating 2 dummy columns and making it work.

View 3 Replies View Related

X Axis Chart Range Stacked Line To 100%

Aug 14, 2014

I am plotting a line chart wherein the X-axis is based on % and Y-axis is based on $. I have 5 scenarios wherein they have different ranges. I want to have the X-axis plotted up to 100%. How to get the X-axis stacked at 100%. See attached file.

View 1 Replies View Related

Stacked Column Chart With Multiple Axis

May 16, 2012

I am trying to chart this -

Code:

20112010
Net ($)Units Net ($)UnitsFFS** $ 808,227 61,370 $ 909,989 56,518 FFS
J-Code $ - 0 $ - 0 MCO*** $ 64,027 5,359 $ 26,691 1,614 MCO
J-Code $ - 0 $ - 0 SPAP/SCHIP $ 72,728 4,612 $ 110,592 6,490

Image can be viewed here - [URL] ...........

But I want units to appear on the secondary axis so its not so small.

View 3 Replies View Related

Stacked Column Chart With Rate Line

Nov 9, 2006

Here's a sample of a chart that I want; However, I want the bar chart to be a stack chart as I have multiple "Failure modes" per month that I want to show the number(or count) of failures per month. Then I want the line chart to remain the Complaint Rate for that month.

I just can't seem to figure it out.

This chart pulls from a data set that looks something like this: ....

View 9 Replies View Related

Secondary Axis Creates Stacked Bar Chart

Jul 11, 2007

When ever I add a secondary axis to my chart my bar chart sub type changes to a stacked bar chart. How do I keep the sub type bar chart? I have attached an example. I have tried playing with the gap and width of the bars but to no avail.

View 3 Replies View Related

Swap Series In Stacked Area Chart

Sep 11, 2007

I have an interactive chart displaying stacked area charts for 2006 and 2007
I currently have 2006 in front of 2007, but as the user chooses 1 of 20 units, it will look better to move 2007 in front of 2006

View 4 Replies View Related

Stacked Column Chart Totals 2007

Jun 28, 2008

Would like to add totals to stacked column chart in Excel 2007.

I have followed same steps listed here [url] but cannot position data labels above column.

Excel only gives me the options Center, Inside End, and Inside Base.

I also tried setting label position with VBA:

For Each co In ChartObjects
For Each s In co.Chart.SeriesCollection
If s. Name = "Totals" Then
For Each dl In s.DataLabels
dl.Position = xlLabelPositionOutsideEnd
Next dl
End If
Next s
Next co

Also tried the following without luck:

dl.Position = xlLabelPositionAbove

For each VBA example I get following error:
Run-time error '-2147467259 (80004005)':
Automation error
Unspecified error

It seems like Microsoft has removed this positioning option for stacked column charts because it works fine for normal column charts. Anyone find a way to do this otherwise?

View 9 Replies View Related

Stacked Area Chart Series Colour Change

Jan 6, 2010

I have a stacked area chart located on its own individual worksheet. I would like to use VBA to apply colours to individual series based on the name of that series. I have applied the following code which I found on the following help forum, changing it slightly to fit my needs: http://www.ozgrid.com/forum/showthread.php?t=91381

View 3 Replies View Related

Excel 2007 :: Gantt Or Stacked Bar Chart Timeline

Mar 19, 2012

I'm attempting to chart data obtained from our phone system to see when users are logged in/on rest.

I'm using Excel 2007.

The data we extract has:
person | status | start | finish | duration

Status is either "login" or "rest"
Start/finish is time (h:mm)
Duration is a formula (h:mm, finish - start)

I want to have a stacked bar chart that shows when a person was logged in/on rest; one bar for each person.

x-axis: person
y-axis: time (8am - 6pm)
legend: status

The problem I'm encountering is that each person logs in and out multiple times throughout the day (therefore, has multiple lines to their name in the data), and I can't get this information to appear on a single bar for each person.

I've sorted the data into a pivot table which gives me the information I want, but how to get the chart.

Row labels
a. Person
b. status
c. start

Values
Min of duration

Ideally, I would like to avoid using a Gantt chart within cells (as it would involve vlookup/if statements), but am beginning to think that's my only option...

View 3 Replies View Related

Put In Trend Lines When Creating Stacked Column Chart?

Apr 3, 2012

Is it possible to put in Trend Lines when creating a stacked column chart?

I've tried in Excel 2003 and 2010 but it doesn't appear that it is possible.

View 3 Replies View Related

Stacked Column Chart (tying Up The Loose Ends)

May 22, 2006

If the user adds 3 new lines, to the data table, – the Series Value Ranges should increase by 3 lines – AUTOMATICALLY(!) to avoid the user to full-around with the chart. It should take care of the 4 Series Ranges and also of the Range for the X-Axis Category Labels. As far as I recall, the way to accomplish it, is by NAMING the ranges with COUNTA etcc BUT, here – the last row is an empty rowc

View 2 Replies View Related

Stacked Chart - Change Bar Colors Based On Date (X Axis)

Apr 19, 2014

I am wanting the colors of the bars in a stacked chart to change based on the date in the X Axis. As the current date arrives, the stacked bar needs to change to various blue shades. If the date is in the future, the stacked bar needs to be various grey shades.

View 2 Replies View Related

Excel 2007 :: Dates By Month On X-Axis In Horizontal Stacked Bar Chart?

Aug 24, 2012

I am working with the Ganntt chart and horizontal bar charts but can't seem to figure out a way to force the X-Axis to behave properly.

In Excel 2007, I am trying to get the X-Axis to show major units of Months. However, in my chart options I can only change the Y-Axis to be Date/Monthly.

Changing my data layout (from the below) to be a vertical format produces the same problem, just in the other direction.

My data looks as follows:

System
Blocker
Production
Migrataion
Retired

Sys1
1/1/2012
780

Sys2
1/1/2012
400
60
90

Sys3
2/1/2013
30
5
1

The Blocker column is formatted as "No Fill" in order to cover a portion of the time-scale.

My X-Axis displays as random dates throughout the period and all of my data displays properly in terms of the scale on the grid.

What is NOT working is that the dates shown on the X-Axis really need to be based on a Monthly scale instead of the randomly selected dates Excel is using.

20120823.xlsx

I can't seem to find the right combination of options to make that happen or force a scale on the X-Axis.

View 1 Replies View Related

Excel 2010 :: Combining 100% Stacked Column With 100% Stacked Line Using 2 Groups Of Data?

Apr 24, 2014

I am trying to create a 100% stacked column which has a superimposed line chart over the top of it.

Basically % of yes and no for two separate datasets, but which share the same characteristics. The x-axis is months of the year.

CSP Yes
CSPNo
All Yes
All No

Apr-13
6
19

[code]....

I can create 2 separate charts. One for the yes/no of one set as a 100% stacked column. I then use 'no fill' on the No column to stop this from being seen.

I can create a 100% line chart for the second data type, and 'no fill' the 100% line that appears.

However, I can't merge the two charts to show the Yes % for one dataset as bars and the Yes % of the other as a line.

I am using Excel 2010 on XP.

View 2 Replies View Related

Stacked Columns With A Total

Oct 14, 2004

I have a stacked column graph showing data for 5 categories for 4 years (4 columns, 5 categories each).

I would like to display a Total above each column. I was able to do this on a single chart by just adding a text box and manually adding the total amounts. However, I would like this to be updated dynamically, as the data will be changed frequently.

Is it possible to:
(a) Have the total display as a data lable, or
(b) Have a text box containing a cell reference

View 9 Replies View Related

Text To Columns (vertically Stacked)

Jul 22, 2009

Had a quick browse through the forums for an answer but as it is quite hard to describe i cant quite find the answer.

Basically I need to split some cells but they have stacked text in them i.e

Cell a1 shows:

666666
part 77777 x 20
5x s452563

Cell b1 shows:

1x 254684564
3x 4481211111 & 5 ea g8373

etc.

When i run the text to columns function i only get the first line of the data, i could ideally like to split the data by spaces and/ or line breaks.

View 7 Replies View Related

Alternate Colors On Stacked Columns Plot?

Feb 19, 2014

I'm trying to find a way to alternate between two colors (white, grey, for example) in a stacked columns plot. Each stacked column should begin with a grey layer then white, then grey and so on. These plots will be created and changed frequently so I cannot manually do this every time.

View 1 Replies View Related

Excel 2007 :: Run Code Only When Double Click In Any Cell Of Three Different Columns

Jul 13, 2014

How to run some VBA code only when double click any cell of three different columns (say A, G,H) and not run in any other cell. This is being run in Excel 2007.

View 7 Replies View Related

Hide Columns In Sheet Based On Value In Double Clicked Cell

Jun 4, 2014

I have a workbook with two sheets, Project Overview and Projects Detailed. In Project Overview column K is different project numbers and what i need the code to do is when this number is pressed it has to go to Projects Detailed and search for this number in column AV and hide the lines that does not correspond with the number that has been double clicked.

In project overview you should only be able to press the numbers from row 9 and down and in Projects Detailed the numbers in column AV also starts in row 9. Some of the cells in column AV are empty and these should also be hidden.

View 2 Replies View Related

A Chart Will Columns And A Line Chart Below??

Dec 15, 2007

I can create a column chart in excel comparing sales in 06 v's 07 for each month in 07, what I'm aiming to show on the chart is how sales have grown or not over a comparative period. A simple enough graph, I end up with about 24 columns (2 for each month and then a gap between each month).

I now want a line chart to show the performance of an index over the same time period, lets say the FTSE100.

I don't know how to get the line chart under the columns on the same graph, using the same x-axis with a small y-axis to the left. I could propably figure out the y-axis bit if I could only get the line chart below the columns.

View 9 Replies View Related

Chart Out Of 2 Columns With Words Only?

Jan 20, 2014

I have two columns, one describing the stage of our client (won, lost, postponed .. ) and the other one describing the lead source (referral, repeater, website, ...). Now I would love to have a column chart out of those two values, to know how many website inquiries were lost / won / postponed .. how many referrals were lost / won / postponed .. also.

View 14 Replies View Related

Stacking Columns In Chart

Oct 5, 2006

I am looking for a way to that I can stack certain columns in an excel chart. For example the first column will be a total and the three next to it will be the breakdown of the first total. I want the second, third and fourth columns to stack on top of each other so that they will equal the height of the first. Is this possible? Also, I'm looking for the simplest solution because others will have to use this.

View 3 Replies View Related

Using Macro So That Chart Will Not Show 0 Columns?

Dec 3, 2012

Any way using a macro so that a chart will not show the "0" columns?

View 6 Replies View Related

Color Code Chart Columns

Dec 11, 2006

I am trying to color code the cubes in my chart. I'd like to be able to be able to specify a specific color per cube. What code what I write for the Sheet to do this?

View 5 Replies View Related

Plot Columns With Chart Macro

Jul 11, 2007

I have 2 columns og data, for example

120
120
120
120
220
220
220
220
320
320
320
320
420
420
420
420

I want to plot them via a chart. But here is the problem..
My code.....................

View 3 Replies View Related

ADVERTISEMENT