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
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
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
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.
View 6 Replies
View Related
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
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
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
Jul 24, 2007
I need code that will check each column from D:P in the " Total" row for a value of Zero. If it finds a zero then delete entire column. This will be the final procedure of a macro that does other formatting things so the number of rows will differ causing the "Total" row to be dynamic. I have the following code that will find the word total, but I don't know how to set the range to offset 1 col each time checking for zero and deleting if true. The word "Total" is merged between columns A:B. see example sheet.
Sub asdf()
Dim c As Variant
Dim Rng As Range
'search the sheet for "Total"
Set c = Cells.Find("Total", lookat:=xlWhole)
'if it is found
If Not c Is Nothing Then
Set Rng = Range(c, c.Offset(0, 3))
View 5 Replies
View Related
Jul 10, 2007
I am attempting to create a chart from data generated outside of Excel 2003 SP2, that has been Copied and Pasted into Excel. There is no metadata associated with this data. I have created a list with the data once it has been pasted into Excel 2003 SP2.
The Workbook has five (5) worksheets, all with the default names (Sheet1, Sheet2, etc.). I paste the data into Sheet1 and reference this from the other worksheets. Sheet2 shows the charts for all the data. Sheet3, Sheet4, and Sheet5 are each for different regions, North, South and West respectively. I would like to enter the formula into Cell: Sheet5!M5 so it auto populates with the appropriate and correct information. Sheet1 information is as follows;
Column B has a header of "CreateDate" and is in the format of; 4-Jun-07
Column O has a header of "Business Unit" and has three (3) possible answers, North, South or West. **I have attached a screen shot of the two colums used named, "Columns.Used.png". I have hidden the columns in between as they contain confidential information.**
I would like a formula that gives a total of one if both criteria are met. The criteria is as follows;
IF Column B on Sheet1 equals Cell L5 on Sheet5 AND Column O on Sheet1 equals West THEN the total should appear. **I have created and attached a sample spreadsheet "Sample.Data.zip"that contains only basic data on Sheet1 and Sheet5 as those are the only sheets relevant.**
View 9 Replies
View Related
Dec 15, 2011
I have a worksheet with a large amount of data, but a lot of cells are zero (because the content of the cells is calculated). I would want to be able to build a macro which can hide all the columns whose total is zero, and also all the rows whose total is zero. The amount of columns and rows will be variable, because i expect to keep adding information continuously. The row with the totals to evaluate is 4, and the column with the totals to evaluate is H. (I cannot make a filter for this one, because there's already one some rows upwards).
View 3 Replies
View Related
Nov 11, 2008
Column A = numerical IDs, multiple entries, may have duplicates that should only be counted once in comparison
Column B = numerical IDs, multiple entries, may have duplicates that should only be counted once in comparison
Need: 1 cell that compares all of the A range to all of the B range and returns a a percentage of repeats. So, if there are 50 entries in A, and only 40 are unique, and B includes 10 repeats (unique, not multiple), then the returned value would be 25%.
View 6 Replies
View Related
Dec 1, 2009
I have filtered a worksheet and want to only total the data in the columns that are visable, is this possible?
View 4 Replies
View Related
Nov 18, 2013
what im looking for is, i have two different rows i.e. col A and col C is the "type".
col B and col D contains "quantity".
i want in column E, listed all unique types in col A and col C and their respective total in front of the next column i.e. in col F.
col A.....col B.....col C.....Col D
150...... 6.........120..... 4
150...... 6........ 120..... 4
2.5....... 6
25 ........ 6........ 25 ....... 2
25 ........ 6 ........25 ....... 2
25....... 12....... 25....... 2
25 ........ 6 ........25....... 2
185 ....... 6 .......150...... 2
185 ....... 6....... 150 ...... 2
View 9 Replies
View Related
Apr 6, 2014
In a worksheet of marks of students, i have entered grades A,B,C,D,AND E.Grades are entered in cells o3,AB3,AO3,BB3 AND BO3.
In BQ3,I want to get -in the range of O3:BO3
a)how many "A" are there?
It should display for example A=2,
b) how many "B" are there?
It should display for example B=2,
c)how many "C" are there?
It should display for example C=2,
d)how many "D" are there?
It should display for example D=2,
e)how many "E" are there?
It should display for example E=2.
In BR3, I want to get >
If A=10, B=8, C=6, D=4, E=2 then
display the total value for the grade letters.
Pls see the attached file for more clarity.
View 7 Replies
View Related
Jul 20, 2009
I am trying to add separate columns together to get a total count of a specific criteria. The formula I am using is:
View 3 Replies
View Related
Sep 25, 2013
I have a worksheet with data in columns F,G,H and I. There is a total in column J. (=SUM(F1:I1)
I've written some code that allows a user to insert additional columns. However, I'm finding it difficult to find a way of changing the calculation in the total column automatically when a new column is inserted.
View 1 Replies
View Related
Jul 10, 2014
I use Excel 2007.
I have a data set that tracks ingredients in chemical products. For example sake the chemical product is a mixed color, and the calculated ingredient is a primary color.
I need to calculate the quantity of two primary colors based on their percentage of the mixture.
Column A contains the mixed color names. Columns B and C contain the percentage of the primary in each mix.
I began tracking this data in January 2009. Each month I add 3 columns to the worksheet. The 1st column contains the monthly mixed color quantity used. The 2nd and 3rd columns contain the calculation of the two primary colors.
I need the formula to calculate the 12 month rolling total for each primary color. (For July 2014 I need to calculate July 2013 through June 2014)
A
B
C
E
F
G
H
I
[Code]...
View 3 Replies
View Related
Aug 25, 2008
I've got two columns of numbers, such as:
(Col A) (Col B)
Cycle Bin
1 - - 3
1 - - 7
1 - - 7
1 - - 2
1 - - 5
2 - - 7
2 - - 9
2 - - 6
3 - - 7
3 - - 2
4 - - 2
4 - - 8
4 - - 2
4 - - 8
4 - - 5
I'm trying to get the total number of columns that have a specific match-up, for instance, how many cells are in Cycle 1 with Bin #7? ....
View 9 Replies
View Related
Jan 30, 2014
I need to be able to count all the blanks in columns other than A but only until the last used cell in column A. I am using a formula right now that counts the blanks in column A until the last used cell but I don't know how to apply the range of column A to other columns like B and C. Here is an example of what I hope to accomplish:
Formula used in A1 that I need applied to other columns but with the range of column A
="Total Blanks: "&COUNTIF(INDEX(A2:A8,MATCH(TRUE,A2:A8<>"",0)):INDEX(A2:A8,MATCH(2,1/(A2:A8<>""))),"")
Here is an example of what B1 and C1, with the formula, would look like if it counted blanks but with the range of column A
Total Blanks: 3
Total Blanks: 6
Total Blanks: 2
[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
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
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
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 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 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 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
Jan 7, 2010
I have a report which has a list of customers, each customer has 24 columns which represent the payment history over 24 months. If a payment has been made for that month the date and time (formatted correctly) will be populated in this cell.
Each customer has a product name attached to it so a product can appear several times. I need is a formula that shows the total payments recieved for a particular month for a particular product. For example.
I have managed to create the following flag which works a treat, it picks up a date an account was set up but looks at 1 column.
View 2 Replies
View Related
