Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Stacked Chart With Double Columns


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 Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Columns & Stacked Columns Chart
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 Replies!   View Related
Stacked Column Chart
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 Replies!   View Related
Two Stacked Bar Chart
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 Replies!   View Related
Stacked Bar Chart
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 Replies!   View Related
Stacked Bar/Column Chart
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 Replies!   View Related
Dynamic Stacked Bar Chart
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 Replies!   View Related
Stacked Column Chart With Rate Line
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 Replies!   View Related
Stacked Column Chart Totals 2007
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 Replies!   View Related
Exasperated With 2007 Stacked Bar Chart
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 Replies!   View Related
Create Stacked Bar Chart/Graph
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 Replies!   View Related
Swap Series In Stacked Area Chart
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 Replies!   View Related
Conditionally Color Stacked Bar Chart
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 Replies!   View Related
Stacked Area Chart Series Colour Change
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 Replies!   View Related
Stacked Column Chart (tying Up The Loose Ends)
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 Replies!   View Related
Secondary Axis Creates Stacked Bar Chart
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 Replies!   View Related
Stacked Columns With A Total
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 Replies!   View Related
Text To Columns (vertically Stacked)
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 Replies!   View Related
A Chart Will Columns And A Line Chart Below??
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 Replies!   View Related
Stacking Columns In Chart
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 Replies!   View Related
Color Code Chart Columns
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 Replies!   View Related
Plot Columns With Chart Macro
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 Replies!   View Related
Chart Not Plotting Hidden Rows/Columns
I have mapped data from Sheet1 to Sheet2 and created graphs in Sheet2 using the data. but when I hide the rows in Sheet2 the Graph is being cleared off. Need a solution so as to display the Graph in Sheet2 while hiding the rows in the same sheet.

View Replies!   View Related
Vba To Switch Columns To Rows In A Line Chart
vba to switch columns to rows in a line chart
I have the following

View Replies!   View Related
Stacked Column Charts
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 Replies!   View Related
Stacked Cell Text
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 Replies!   View Related
Merging Code For Hiding Columns And Setting Chart Axes Values
I'm trying to create a code that when run hides a selection of columns and defines the minimum and interval value for a chart on the active worksheet. My attempt is assigned to the 'update skills' button at the top of the "GRAPH" worksheet of the attached workbook.

View Replies!   View Related
Color Column Chart Columns Based On Thresh-hold Line
I want to show 8 members of staff's names, with their sales closing percentages. I want then to produce a chart showing their percentages as a column with a line showing 16% going across the chart showing who is above and who is below the target.

Ideally i would also like to change the colour of the columns or background of those below the line to show who is under target.

View Replies!   View Related
Macro Delete Stacked Numbers
I already have a few macros I run in order to sort data. I am able to show problem data by using a macro to perform an output that puts the number "1" in a cell if there is a problem.

I'm looking for some help if someone could create/show me a macro that can delete stacked numbers. For this I mean if there is the number "1" in cell A1 and a "1" in cell A2, I want to delete the bottom of the two which means remove the "1" in cell A2 so that there are no 1's that are stacked. The number "1" in cell A1 and a number "1" in cell A3 is fine.

View Replies!   View Related
Bargraph With Grouped And Stacked Bars?
This is the data:

jan09 feb09 mar09 .....
Division 1
Division 2
Division 3
Division 4
Division 5

jan08 feb08 mar08 .....
Division 1
Division 2
Division 3
Division 4
Division 5


The graph would be a bar graph with 2 bars next to each other per month. each bar would be stacked by division. The goal is to compare for example sales in 08 with sales in 09 showing 2 bars next to each other split by division.

View Replies!   View Related
Stacked Bar Graph With Average Line
We are trying to create a stacked bar graph with an average line. Each time we try to add in the average data to the graph it adds it to the stacked bar. The stacked bar should represent the inpatient & outpatient cases at a hospital for the current year (months showing across the as columns). The line should represent the previous 2-yr average total. Anyone have an idea how to add a line to the stacked bar graph? It has us stumped.

View Replies!   View Related
Stacked Bar & Line Graph
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 Replies!   View Related
Stacked Column & Line In Same Graph
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 Replies!   View Related
Chart Hyperlinks: Attach A Macro So That When The Chart Is Clicked It Returns To Sheet - Home
I know this has been discussed a number of times, but here is my problem
I have three charts in my workbook. I want to attach a macro so that when the chart is clicked it returns to Sheet - Home. I have using the following:
worksheets("Home").activate. But after I protect each chart and the workbook, and save and exit. When I reload the Workbook it has forgotten the assigned macros and nothing happens.

View Replies!   View Related
Odd Chart: Combine Data From Multiple Worksheets And Make A Chart
I am trying to combine data from multiple worksheets and make a chart. I have about 200 keywords in every worksheet (about 50), and some of them repeat themselves through worksheets and some don't. For every keyword, I have an associated value in the next column that I want to portray over time (each worksheet is for a different period).

So what I need to figure out is how to be able to pick any 10 keywords from the worksheets and put them in a line chart where I can see the associated value for each period for every worksheet so I can compare my keywords' efficiency. The tricky part is that some worksheets do not contain the keyword and other worksheets contain the keyword in a different cell than the previous wsheet.

View Replies!   View Related
Combine (Overlay) Bubble Chart & Point Scatter Chart
I would like combine (overlay) a bubble chart with a connected point scatter chart. I understand that, without VBA, this is not possible. However, I understand that, by using VBA, the markers of a scatter chart can be configured as circles with their size proportional to values in a specified column. This pseudo-bubble chart can then easily be combined with a connected point scatter chart.

My question is: does anyone have any VBA code to share that shows how to configure a scatter chart as the type of pseudo-bubble chart described above.

View Replies!   View Related
Line Chart - 12 Month Chart Moving With Dates
Is there a way to display only the current month and the past 11 months in a Line Chart in Excel? So if I was to print Jan 2008 Excel graph, it would only display Feb 2007 - Jan 2008 data charting.

The spreadsheet of the data contains data for Jan 2005 - Jan 2008 so far, but only the current month with the past 11 months should display in the line chart depending on what is the current month.


View Replies!   View Related
Pareto Chart, Set Line Chart Origin At Zero
I have a pareto chart(Bar & Cumulative Line Chart) that I would like to have the line orginate at x = 0 & y = 0 without changing the position of the other points on the line chart.

Basically this is for better visual appearance. When I add a 0 to the table, it skews the alignment of the line chart with the corresponding bar chart.

View Replies!   View Related
Basic Chart: Set A Chart Up With The Time Been On The X - Axis
I got a set of data which is only 2 colums collecting data problems. The output i get is a time stamp and a fault. Im looking to set a chart up with the time been on the X - axis and number of problems per hour on the Y - axis.

View Replies!   View Related
Chart Making- Chart With 3 Data Series
I have a chart with 3 data series. The series are located in columns A, B and C respectively. Series I is a general number anywhere from 0 to 100,000. Series 2 is also a number, but is is devided by series 1. So, if series 1 was 100,000 then series two would be 25,000/100,000 which is 0.25. Series three will always be numerator of series 2 or 25,000 in this example. The numerator, or the 25,000 will never change, so, in my example, series three will be a straight line across the chart because it is always 25,000.

In my example, the .25 is plotted on the left value axes, and series one is plotted on the right value acccess (secondary axis). Series three is just a line in the middle.

My problem is that sometimes the line, series 3, doesn't match the values in both the right and left values axes. So, if series one is 48,000, then series two would be 48,000/48,000 = 1, and series three would be 48000 - the straight line. The third series should be a line touching the 48,000 on the right and the number 1 on the left. It does touch the 48000 on the left, but is below the number 1 on the left.

View Replies!   View Related
Convert Scatter Chart To Bubble Chart
I would like to combine / overlay a bubble chart and scatter chart with straight connectors.

I understand that, without VBA, it is not possible to combine a bubble chart with a scatter chart.

Unfortunately, I am a VBA newbie, and so I cannot write my own code (though I can usually adapt code to my specific environment).

My question is: does anyone have VBA code to share that will convert a scatter chart series (x,y data in 2 columns) to a bubble-style chart (bubble radius in 3rd column)?

View Replies!   View Related
Line Chart To XY Chart And Vice-Versa
Attached is the sample data worksheet. Chart 1 is XY type chart using Seconds (2nd column of sample sheet as x-axis from 42510 to 42530). How do I change it to Line chart using Time (1st column of sample sheet as the X-axis) retaining same data from 42510 to 42530 on both primary and secondary axis?. And how do I again change it back to XY chart?

View Replies!   View Related
Bar Chart And Overlaying Scatter Chart
I'll attempt to explain what I'm hoping to do. I have a column of data that I want to plot out into a chart. For example the data points might run from -1.50 to 2.5.

Let's say there are 20 data points in the column and they are spaced thruout the range shown above. They tend to cluster amoung themselves into 2 or 3 distict groups.

I want to first produce one horizontal bar that runs from the -1.50 to 2.5 overall range and secondly, I want to overlay a scatter chart horizontally over the bar showing where the data points lie within the range and also so I can visually see the clusters of points.

With the data residing in a column, when I generate the scatter chart, the points are laying verticle within the chart and spreadout horizontally. I can manually get what I want by narrowing the chart down to the point that the points lie on a straight vertical line, but I haven't been able to figure out how to "rotate" the chart 90 deg to overlay the scatter points within the bar chart.

Naturally, the optimum solution would be such that I could generate the charts originally and then allow the spreadsheet to generate the new charts as we modify the data values, etc.

View Replies!   View Related
Chart Objects: Chart Object Model
I'm looking for the excel model object chart and class diagram. I find the model object's description in the microsoft page, however i'm liked to have the object model and the class diagram in chart or picture.

View Replies!   View Related
Change Chart Series Pasted From Another Chart
I want to use a macro to change attributes of a series in a chart. Unbelievably, if the series has been pasted into the chart from another chart, and although the macro can address the series and even return values (eg name) correctly, the selection simply cycles to one of the original series on the chart.

View Replies!   View Related
Is It Possible To Have A Double VLookup?
On one sheet I have an array of 4 cols. It looks like this:

123 Chris 12345 Jones
123 Chris 23456 Pete
123 Chris 34567 John

On the main sheet there are also 4 cols. In cell A1 I enter a number, in A2 I have a VLookup to get the corresponding name for the number entered in A1, which works fine, I type 123 in A1 and get Chris in A2.

In a perfect world I would like A3 to become a dropdown with 12345, 23456 and 34567 so the user could then select one of those, and by doing so, A4's VLookup would give Jones, Pete or John.

I don't think a dropdown can be populated this way - am I stuck using VBA?

View Replies!   View Related
Double Inequations
Is it possible to enter double inequations? Excel returns "false" even it is obviously true. If I type =1<2<3 the result is "false".

I can get the correct result using =and(1<2,2<3), but that makes it longer, and if I have more formulas inside instead of numbers I'll have to repeat the middle one, it will take the place, but only in oreder to compare it again.

Is there anything that can be done with this?

View Replies!   View Related
Double Lookup For Name/Value
I have a list like this:

xxxxxxxxxx1-jan | 2-Jan | 3-Jan
-------------------------------------------------
Location 1
Bob Smith ----B2--- C2 ---- D2
Frank Thomas-B3---- C3---- D3
Location 2
Bill Clinton----ETC ALL
George Clinton

And another sheet, a similar list, (just names and randomly sorted) but populated with the values I want,

xxxxxxxxxxx1-jan | 2-Jan | 3-Jan
-------------------------------------------------
Bob Smith --- 2 -----5------ 1
Frank Thomas 3----- 1 ------2
Bill Clinton ----4----- 5 ------2
George Clinton 4----- 4 ----- 4

I want to check the name in A2 on the first sheet against all of column A on the second sheet, then find the number value for the correct day for that name.

How can I write a formula that will look up these values for me? I looked at OFFSET but unfortunately I don't have a lot of excel experience (yet)


View Replies!   View Related
Double Spacing
I have a list with fractions such as 25 1/4, 33 5/16, 20 15/16, etc. i have them formatted as FRACTIONS 2 DIGITS 21/25. Manny of those have double spacing ex: 25 1/2, So i am wondering if theres a way to take the extra spacing off the ones that have double.

View Replies!   View Related
Double Lookup
=INDEX('sqft - PC each bldg'!D2:D1705,MATCH(Sheet5!B3&Sheet5!F2,'sqft - PC each bldg'!A2:A1705&'sqft - PC each bldg'!C2:C1705,0))

my result is N/A

I wonder if it has to do with both lookup ranges being columns?

View Replies!   View Related
Double Vlookup
I have a double vlookup problem here.

Here's a simple illustration:

A B C D E F G
1 1 1 1 One
2 2 2 2 Two
4 4 3 3 Three
3 3 4 4 Four
5 5 5 5 Five

I need to match A,B with E,F.

If they match, I need to display the string in G in C.

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved