Stacked Column Charts
Jul 10, 2009
I'd like to create a stacked column chart that compares monthly results from the sales staff but can't get excel to show what I need.
Each salesman has a total monthly sales figure which includes an element of profit and I'd like to see the splits in a stacked column chart. E.g in May, Simon's total was £7295 of which £863 was profit.
MayMayJuneJune
TotalGPTotalGP
Simon7295863121231912
Mike32397480995670199644
Gordon39567472631393362539
The chart should have a column for each salesman and show both the total figure and the profit for each month in the same column so with May and June figures there should be 6 columns on the chart.
How do I lay the data out in excel to get the right graph?
View 9 Replies
ADVERTISEMENT
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
Mar 15, 2012
I need to show a chart with new and return visits 2 years side by side. I also need to show a budget line and 2 seperate utilization lines. How to show this.
View 1 Replies
View Related
Jan 27, 2012
Using Excel 2007. Is there a straightforward way to do a waterfall chart?
eg. stacked bars running from left to right.
First Column = 2011 Headcount
2nd Column = stacked bar with additions (by category) - stepping up from the 2011 total.
3rd Column = stacked bar with reductions (by category) - steppind down from the first column + 2nd colum total.
4th column = 2011 exit (which will be at the same height as the bottom of the 3rd column).
View 3 Replies
View Related
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
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
May 28, 2007
I would like to make a graph in Excel, where I present both a stacked column and a line with two different axes. Including a clustered column and a line in the same graph with two different axes is easy, as this combination can be found in the custom types selection in the chart wizard. However, there is no such alternative as a stacked column and a line with two different axes. Is combining the two manually possible?
View 2 Replies
View Related
Nov 22, 2013
I want to compare the sales from Jan'12 - Oct'12 VS Jan'13 - Oct'13 by showing them in stacked Columns. So will have 2 stacked columns one for year 2012 and beside it for year 2013 and each one will show the months.
View 3 Replies
View Related
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
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
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
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
Apr 30, 2014
I have a stacked column chart that I need to show an average on, that is on a second axis and shown as a line rather than a column.
I have tried moving it to a secondary axis but then it keeps changing the graph to show only the average.
this is just one of about 25 graphs I am having to do like this.
stacked 2 axis.xlsx
View 2 Replies
View Related
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
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 etcc BUT, here – the last row is an empty rowc
View 2 Replies
View Related
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
Jun 27, 2013
My DB is in table format . I use this table as source data for 2 barcharts and 1 pie chart.Following are my table headers
Costs|exp heads|Month1|Month2|...|Month n|Spark lines|Average
When i add a month coloumn,Sparklines and Average coloumn should get updated automaticaly.Now this is not happening even if the data is in table format.I also want the graphs to be automaticaly updated.
View 2 Replies
View Related
Aug 5, 2008
Is there a way to make multiple charts off of 1 big data sheet. Sounds easy but there is more.
Sheet name is Field
Column A is Name ( about 40 different names)
Column B is Date (x axis primary and secondary)
Column D is Oil (y primary axis)
Column G is Water (y primary axis)
Column E is Gas ( y secondary axis)
Column M is MCFE (y secondary axis)
There is about 2-3 thousand rows, updated monthly. I need to make a graph by each well name.
1) can I make multiple graphs that can just look at the "field" sheet and then breakout just the 1 well name that shows up on the chart sheet that I create
I've tried pivot charts but you can't have secondary acess because it resets every time.
Basically, make multiple charts that will graph the data of a specific name in column A
View 9 Replies
View Related
Apr 28, 2013
I am using Excel 2010
I have over 800+ pages of chart that only takes up 6 columns and around like 9000+ rows.
I wanted to print this chart on paper and need hardcopies. However, the chart in its current setup prints only on the left half of the page leaving the right half empty.
How do i make use of the full space properly? Each chart has a "page number" on it so I want the chart to print continuously from one half of the page onto the next half and then the second page, third, etc.
Here is a visual demonstration of how things currently are and how i'd like to get them to be:
As you can see, This is the first of many charts and its numbered Page 9 and next one is page 10.
Pic1
How this looks when i try to print, it's only on the left side. right is all blank
Pic2
How i want it to look like upon printing
Pic3
As you can see in the last picture, once page 14 chart has no space it automatically continues chart on right side of page and then moves on to print rest.
[URL]
View 7 Replies
View Related
Sep 5, 2012
I am trying to put some charts into a report that is pivot table based. I have some code that will work if the pivot tables stay stagnic but the users may change the tables around so that could be an issue of new data. I have the following code where I changed the source to the pivot table name (general name because of numberous report possibilites). I have taken out the other charts because they are just a variation of the chart 1. I am crashing on the line with the * on it.
Sub UWTierChart()
Dim oCell As Range
Dim oChart As Chart
Set ws_data = ActiveSheet
'Chart 1
Sheets(wsPT).Select
Range("B21").Select
[code]....
View 2 Replies
View Related
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
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
Oct 27, 2009
I have attached the relevant spreadsheet for which I need to alter the color of the columns based on Site number ( Sheet 1). % Mortality will be represented in the Y-Axis, and the Site numbers would be on the X-Axis. All columns (% Mortality) except one will be of the same color, and the one of a different color will indicate a specific site. As an example, site 86 is colored differently. The way I require the chart to look is shown on Sheet 1.
After reading through some great posts on Ozgrid, I managed to do this using conditional formatting (Sheet 2), but that sort of falls short because I am required to add a data table to the chart, and the parameter that is indicated by the column bars happens to appear twice in the data table.
I was wondering if this can be automated maybe using VBA, but with the possibility of simply matching the color of columns with the font color of respective entry in the data series.
View 9 Replies
View Related
Feb 9, 2014
I wish to plot a Stacked column graph of dates work is completed. Several peoples names along the bottom and dates up the side. The stack shall be broken into 6 steps, each step denoted by the date it was completed.
I would also like a marker at the top of each stack indicating the deadline date.
I'm working from a large table of dates.
View 1 Replies
View Related
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
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
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
Sep 20, 2006
how to create a stacked bar & line graph together.
I know by default, I can choose to have a stacked bar, OR a line graph, OR a basic bar & line graph.
But I need to take a step further and have a stacked bar WITH a line graph.
options in which I could combine the above graphs?
View 4 Replies
View Related
Oct 27, 2006
Is it possible to have stacked text in a cell? Turning wrap text on doesn't quite work since an "ol" is the same width as an "m".
Example: P
R
O
D
U
C
T
View 3 Replies
View Related
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
