Create Three Stack Bars Chart With Different Data
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.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Format Chart Bars Based On Cell Reference
I'm trying to get the bars of a chart to change colour depending on the selection from a drop down in a cell. The drop down is validated to be one of four options which changes the figures displayed in the graph using index matching.I would really like the colour to change to represent what the option being selected is. I used some VBA code before for changing the cell colour depending on the selection made to get over the 3 condition limit. Could this be easily edited to change a bar graph colour? All of the references I can see on line refer to changing the colours of bars based on their value, I don't want to do this, more an independant cell value! My previously used code is below: Private Sub Worksheet_Change(ByVal Target As Range) Dim iColor As Integer If Not Intersect(Target, Range("d9:d129")) Is Nothing Then Select Case Target.Cells(1) Case "Commercial Final State" iColor = 49 Case "Commercial Interim" iColor = 31
View Replies!
View Related
List Box To Create Chart Data
I am trying to have a list box that when clicked will change the chart data to whatever is selected. There are 2 options you can choose from. Order Cost (Net) and Order Total (Gross) The problem I'm running into is that the data is in 2 different rows. How can I create the drop down box to display the one that is selected? ...
View Replies!
View Related
Horizontal Bars Scroll Bars!
I am trying to derive the EMI for a Loan Amount and also chart a PIE graph for the same.. Instead of Manually feeding the values such as : Variable 1 : Loan Amount : Min : Rs 50,000/- Max :Rs 5000000/- Each Spin (1 Unit) -Rs 25000/- Variable 2 : Interest Rate : Min : 5% Max : 30% Each Spin (1 Unit) -0.25% Variable 3 : Tenure/Duration : Min : 6 months Max : 30 years Each Spin (1 Unit) - 6 months I want to have a Scroll-Bar where the values can change Automatically but am not aware of using the same... Can someone please help me with a small attachment with the above variables attached to it..The values drawn should be displayed as well above the Scroll-Bar and maybe can make the Min and Max more dynamic by storing it somewhere in the Sheet.. I am looking for Non-VBA solution to do the same..
View Replies!
View Related
Create Macro To Chart Data With Location As Object In Active Sheet
I have been trying to create a macro in excel to chart a selection of data and to output the chart on the active sheet where the data was taken (as opposed to a named sheet). So basically, I have about 300 worksheets with data, and I would like to have a button on each page that automatically charts that data when clicked, and outputs the chart to the page where the macro was clicked. However, I have not been able to figure out a relative reference that will allow me to make the LocationasObject reference simply the ActiveSheet as opposed to a specifically named sheet. See my code below, which references an output to a worksheet called "Charts". Right now, all of my charts are outputting to the sheet called "Charts", as opposed to the active sheet. Sub ConsDiscChart() ActiveCell.Offset(29, 11).Range("A1").Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlDown).Select ActiveCell.Offset(0, 1).Range("A1:B1").Select Range(Selection, Selection.End(xlDown)).Select ActiveCell.Offset(0, -1).Range("A1:C24").Select Charts.Add ActiveChart.ChartType = xlLineMarkers ActiveChart.Location Where:=xlLocationAsObject, Name:="Charts" With ActiveChart .HasTitle = False .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = False End With End Sub
View Replies!
View Related
Create A Chart To Create Totals Based Upon Different Keys
Trying to create an excel chart to create totals based upon different keys. I need to be able to calculate how many customers there are by Manager and then By Rep. Then to figure out how many were New, Current, Total # of RSVP and attended for that Rep. Below is how I have started but I am having some problems getting certain parts. I know when I get one the rest will fall into place. I can calculate how many total customers by manager and by rep just by doing a Countif command but how do I determine the # of New, Current etc. Is there a If Than command? Managers Totals are simply his reps totals. Example.. A B C D E F G 1 Manager Rep Customer New Biz Current # RSVP # Actual Attend Need totals to look something like this.... A B C D E F G 1 # of Cust # New # Current #RSVP # Actual Attend 2 Manager 3 Rep 1 4 Rep 2
View Replies!
View Related
Create Chart From Selection
I have a table of data which moves up and down my report depending on user input changes to the source data. I have written some VBA code to generate a chart based on this table of data. I have managed to create a basic chart from this table. However I need to change the series (on the chart) from rows to columns so that it is displayed correctly. For this I need to have the cell references within the code belonging to the actual chart. If I was writing the code for the chart with an absolute reference I would write it as: ActiveChart.SetSourceData Source:= Sheets("Group").Range("B50:F53"), PlotBy:=xlColumns This obviously works fine, however when a user makes a change to the source data the table is now out of sync with the chart references. I am trying to write it as: ActiveChart.SetSourceData Source:=Sheets("Group").Range(ActiveCell.Offset(-1, -1), ActiveCell.Offset(2, 3)), PlotBy:=xlColumns Where am I going wrong? My full code is as follows: Private Sub CreateRegionChart() Worksheets("group").ChartObjects.Item(2).Delete Range(ActiveCell.Offset(-1, -1), ActiveCell.Offset(2, 3)).Select Charts.Add ActiveChart.ChartType = xlColumnClustered 'ActiveChart.SetSourceData Source:=Sheets("Group").Range(ActiveCell.Offset(-1, -1), ActiveCell.Offset(2, 3)), PlotBy _ :=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:="Group" With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = "Title" .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = True .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Label" End With
View Replies!
View Related
Create Scrolling Xy Scatter Chart
I have downloaded a file called "scroller.xls" under the section "Excel charts". The file was made by Andy Pope and shows how to make a graph dynamic by combining Named Ranges and a scroll bar. My chart is actually XY scatter chart with data points connected with smooth lines. I followed but when I start scrolling, the data points (smooth lines) got "eaten up" as I move. I tried line chart and it works perfectly. Does scrollbar work for XY scatter chart? Is there a different formula for XY scatter chart? And I want the chart to be in new sheet, but I couldn't put the scrollbar in new sheet. I would like to know if it is possible when the chart is located in new sheet because my chart is quite large.
View Replies!
View Related
Create Gantt Or Timeline Chart
I tried so long I finally gave up and drew this by hand in MS Word: But I wonder if you guys could help me chart this automatical in Excel. I want to chart the time period a ship (Vela, Serpentine, Rainbow etc) are contracted. I want a specific color for the firm contract, and another for the remaining optional contract. If a ship is under construction I also want a bar showing when it's done. Each ship has a rate. I want this written on the bar. In "Vela's" case there are to rates for the same contract: The first 740 days the rate is 24,5 the rest of the period it is 29. I also would like to be able plot an additional contract for the same ship for example after "Syrena" is done in yr 2009.
View Replies!
View Related
Create A Pie Chart In 2007
Originally Posted by Question Create a well labelled pie chart on a separate worksheet to show the profit made by each of the Liverpool departments to the overall profit for 2006. On the labels show the percentage contributed by each department. I want to create a pie chart in Excel 2007. The data is not next to each other in the columns. How do I create a chart so that it includes the legends as the various departments and the data shown as the figures given under 2006?
View Replies!
View Related
Create Chart Automatically Via Code
to write a code that would create a chart automatically in another worksheet when a button is clicked. I have attached the sample data that I am working on. Each row in the sheet represent 3 coordinates, which are: coordinate # 1 = start, 0 coordinate # 2 = centre, level coordinate # 3 = end, 0
View Replies!
View Related
Create Chart For Each Row In Worksheet
I'm trying to loop through a worksheet where each row is an individual record. I need a macro to read the row and create a chart on a separate worksheet for that row, then move on until a chart has been created for each individual row. In English the problem is: Read Row 1 Create chart based on row 1 data in new worksheet 1 Read Row 2 Create chart based on row 2 data in new worksheet 2 And so on
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
Create Chart/Graph From Text Strings
Can I build/present a "Pie" chart DIRECTLY from a list of "ABC" letters WITHOUT counting the occurrence of each one of them and using the results [nor VBA / nor Pivot-Table] - which is the trivial way of building charts !? An example of such a list will be: A A A B B C C C C C
View Replies!
View Related
Scatter Chart To Create A Map (of Sorts)?
I'm trying to create a very simple map. I've got three columns. Member, X, Y Naturally, the first column contains someone's name. The other columns contain XY coordinates. These coordinates start at 375 and end at 499 on both axes. I'm needing the points to show the member name and xy coordinates in the popup when hovering over the point. How do I accomplish this? Here's some sample data. MEMBER X Y JOE 397 397 JIM 421 384 JANE 467 406 JEFF 389 395
View Replies!
View Related
Dynamically Expand Range To Create Chart
See the attached example. I have data listed as shown, but need the chart to automatically update whenever a new sales figure is added to the next month. I know you have to use the OFFSET to create dynamic ranges but I can't get it to work horizontally, only if my data is laid out vertically.
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
Stack Toolbar Buttons
Is there a way to stack toolbar buttons on two rows instead of one row? I have a floating toolbar that is created when a workbook is opened. The toolbar has 16 buttons (all in a row) and gets in the way because it is too long. I would like to display the toolbar with two rows of eight buttons instead of one long row of 16 buttons. Is there a way to create a floating toolbar that when created will display the first eight buttons and then “wrap text” /”carriage return” itself and then display the final eight buttons?
View Replies!
View Related
Create Pie Chart From Table Summary Results
Attached is five months of dummy sales data for eight products. My objective is to filter this data with date ranges (using Column A in Data sheet), and have the corresponding pie slices (shown in Pie Chart Sheet) be the summation of the Products grouped by their designated letter. Currently, the result I am getting is 6 pie slices for "Product A" and this is wrong. I want to see "Product A" show up only once in the LEGEND and only as one aggregated pie slice. The same holds true for the rest of the Product Letters. I want to avoid using Pivot Tables. My objective is to keep my layout clean and simple. I would like to know if anyone out there could help me figure out a formula that will automatically catagorize all of the resulting filtered data by the Product Letter they share. Once the formula categorizes or groups together all of the resulting filtered data by Product Letter, I would like the formula to calculate a summation for each Product Letter category. After the formula finishes the summation task I would like the formula to feed these results to a Pie Chart. The resulting chart I would like to see will show individual pie slices for each Product Letter resulting from the date range filtering operation performed on Column A. The resulting letters can be anywhere from "A" to "H". My goal is to only have one individual pie slice representing each of the Product Letters resulting from a Date range filter. I thought such a task would be as easy as baking a pie, but it's turned out to be beyond my Excel skills.
View Replies!
View Related
Select Defined Cells And Stack
I have 65,000 rows of numerical data in column A. In column B are selected values from A. I need to put values from non empty cells in column B to C and "stack" them in a contiguous column with no empty cells. (Please see attached).
View Replies!
View Related
Macros Following The Call Stack In Reverse
I am trying to determine if anyone has seen a problem like the one I am about to describe. I have created a huge Excel Program with multiple modules and and several macros in each module. Each macro performs a function and then hands of to the next macro. The overall program is sometimes required to go back through almost the entire process once or twice depending on the data it is handling. My problem is that at the end of the procedure, when the last macro runs and gets to the final End Sub, instead of shutting down, it starts going back through the other end subs of the previous macros. I have toggled it one move at a time and it goes from the last macro, back through each of the previous macros, following the call stack in reverse order. in some cases, it will go to the end sub, and then go through the last commands that it went through in that particular macro, repeating steps already taken and devestating the data with orders that should not be repeated. It finally will lock upwhen it gets to a place where an order is given for the macro to go someplace that no longer exist due to previous, PROPER macro execution. Has anyone here ever seen any behavior like this out Excel? The only time this does not happen is when the data the program its handling does not require Excel to repeat its travel through the macros a second or third time.
View Replies!
View Related
Create Surface Chart Via Macro Code Based On Selection
I want to write a macro to add a surface chart for a Data Range which includes 6000 data points. But the series selected for the chart don't cover all Data Ranges, only part of them. Public Sub AddChart2(LastRow As Integer, LastCol As Integer) Dim cht As ChartObject, currentSheet As Worksheet Dim rng As Range, newRow As Range, srcRange As Range Dim colIdx As Integer colIdx = 5
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
Out Of Stack Space/can't Stop Loop
I've got this code to display a certain cell from multiple files, and functionally it works, but I get a out of stack space error after it runs for a while. I'm sure this is because the loop doesn't know when to stop, which I thought would be solved by having " Do Until sBook = "" " instead of Do; however, then the code will not run at all. Private Sub Worksheet_Calculate() Dim sBook As String Dim sFilePath As String On Error Resume Next Application.EnableEvents = False Roe = 3 Do
View Replies!
View Related
Condiditional Formatting - Out Of Stack Space - In Change Event Code
the code i have got is attached below but the problem i am having is when i enter the letter "H" which is calculated in AJ and i enter it fast it comes up with the error "Out Of Stack Space error 28". AJ in the code below is where the cumlative value is stored, and AI is the value that it is measured against it AJ is greater than AI the message is displayed. Private Sub Worksheet_Change(ByVal Target As Range) Dim rRow As Range Dim icolor As Integer Dim ifont As Integer With Application .CellDragAndDrop = False .CutCopyMode = False End With If Intersect(Target, Me.Range("TABLE1")) Is Nothing Then Exit Sub Me.Calculate For Each rRow In Target.Rows If Me.Cells(rRow.Row, "AJ") > Me.Cells(rRow.Row, "AI") Then rRow.ClearContents MsgBox "No Holidays Left or No Holidays setup Against Them " & Me.Cells(rRow.Row, "AI") & " days."............................
View Replies!
View Related
Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart
I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart: 1) Weather data (temperature) by region: So one region, would be: Northwest I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month. 2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region. 3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data). What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.
View Replies!
View Related
Scroll Bars In A Form
What I need to do is add a scroll bar to my text box in my form. I used the properties of the text box to add a scroll bar but when you preview it you can't see it. When you click somewhere inside the form it appears and is workable but not when it hasn't been clicked on. How do I make the scroll bar appear from the start. this is a vertical one ad is on a text box within the form
View Replies!
View Related
Multiple Menu Bars
I have some code that creates multiple new menu bars for a user which each have there own controls. I need to know which control is selected by the user for onaction. The example below is where there are up to 20 new menu bars with names Tract 1, Tract 2, etc. For each Tract, there is a controlbutton titled Absoprtion and I need to know which "Absoprtion" button was selected to run the "ViewAbsorption". I need to use th For next function because the number of menu bars could vary. Dim objMenu As Object Dim objViewMenu As Object For y = x To 39 Name = "Tract" & y - 19 With Application.CommandBars("Worksheet Menu Bar").Controls Set objMenu = .Add(Type:=msoControlPopup, temporary:=True) objMenu.Caption = "&" & Name End With With Application.CommandBars("Worksheet Menu Bar").Controls(Name).Controls Set objMenu = .Add(Type:=msoControlButton, temporary:=True) objMenu.Caption = "&Absorption Schedule" objMenu.OnAction = "ViewAbsorption" Next Y
View Replies!
View Related
Hide Command Bars
I have opened an Excel file (map1.xls) and changed some little things in that file. after that I open a new Excel file with some VBA code in it. In ThisWorkbook I have this ...
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
Hide Menu Bars In Only 1 Workbook
I have a workbook that I created as an interface for my workplace. I disabled the File, Menu, Edit, etc...menu bars through .Control("x").Visible = False and .Enable = False as well Now when I open a new workbook all the menus are there still which is good but when I open a previously saved workbook all the menus are missing. Is there a way where I can have ONLY my workbook have the menus gone and for them to appear in other workbooks that were saved?
View Replies!
View Related
Hide Standard Menu Bars
This is the code I use to temporarily remove menu barsfor a spreadsheet that is managed by user forms. I have code at the close of the program to replace the menu bars. The code work well although and it places a list of enabled bars in the range C1:C50 on the sheet "Bars". The range C1:C50 is not locked before the sub routine 'Hide Menus' runs. However after the sub routine 'Hide Menus' runs, the range C1:C50 is always locked and I don't understand why this is so, I would prefer it not to be. Sub HideMenus() Application. ScreenUpdating = False i = 0 Worksheets("bars").Range("c1:c50").Clear On Error Resume Next For Each Allbars In Application. CommandBars If Allbars.Visible = True Then i = i + 1 With Worksheets("bars") .Cells(i, 3) = Allbars.Name If Allbars.Name = "Worksheet Menu Bar" Then Allbars.Enabled = False Else Allbars.Visible = False End If End With End If Next Application.DisplayFormulaBar = False On Error Goto 0 Application.ScreenUpdating = True Opening.Show End Sub
View Replies!
View Related
Display Floating Bars On Same Line
Is it possible to display all of the bars from a floating bar chart on the same line. The effect would be a single horizontal bar that turns "On" and "Off" from left to right. I'm not sure of the application, but it might represent when a room is occupied over time. I think one can create this effect using Andy Pope's "Column Chart with Varying Width Bars" charting technique (provided on his web site http://www.andypope.info/charts.htm ), but is there a more direct approach?
View Replies!
View Related
Force Display Of Vertical Scroll Bars
I have created a form that has two textboxes on. It is used to edit existing data that is selected by a combobox on the same form. Is there a way to force the textboxes to show scroll bars if the text exceeds the textbox height or just have them always shown? It is difficult to distinguish on some of the data whether the data goes beyond what is visible. Without actually clicking into that textbox the scroll bars will not show. Is this possible?
View Replies!
View Related
Deleting BuiltIn Command Bars VBA
I have the code below. But When I run it, the line marked * throws up an error. I do have custom built toolbars in my spreadsheet. It should delete them all. I am using Excel 2003. Sub DelCommandBarsCustom() 'Del all command bars of specific criteria For Each objCommandBar In Application.CommandBars If objCommandBar.BuiltIn Then * objCommandBar.Delete End If Next objCommandBar End Sub
View Replies!
View Related
Custom Error Bars On Bar Charts
I created a bar chart with horizontal (category) labels: winter, spring, summer, fall. Y-axis label is percent. For each category there is data for blk rats, Norway rats, Mice. For each species and category the standard error is different because it is based on several years of data for a given season. When I try to display the std. error (using custom, fixed value) it treats each species as a series and only lets me choose one value. in other words the std. error would be the same for blk rats in winter, spring, etc. How can I use the individual values?
View Replies!
View Related
Bar Charts - Change Bars To The Category Name
I have a list of salesmen and their performance to date (on a percentage basis) which is sorted lowest percentage down to highest. What I would like to do is to graph this as a bar graph (no problem there) but for the bars to be replaced by the names themselves! So, I have data like this:........
View Replies!
View Related
|
TRACKER
