How To Make Bridge Charts Waterfall
Feb 4, 2014I have a data and did not know how to create a bridge charts.
View 1 Replies
ADVERTISEMENT
Excel 2007 :: Waterfall Charts - Stacked Bars Running From Left To Right
Jan 27, 2012Using 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).
Make A Distance Between Charts?
Sep 21, 2013I wrote a code to make all my charts and it made but all charts stocked together
P.S : "The red part in this code is my try to make a distance(space) between charts but it doesn't work"
Code:
For u = 1 To o
ActiveSheet.Shapes.AddChart2(303, xlColumnStacked).Select
ActiveChart.SetSourceData Source:=Sheets("sheet1").Range(crgf(u), crgl(u)), PlotBy:=xlRows
ActiveChart.SetElement (msoElementDataTableWithLegendKeys)[code].....
Charts - Make Second Axis Series Always Appear Above
Sep 10, 2012I have a combination column and line chart with the line series on the secondary axis. Is there a way that I can tell excel to scale the secondary axis so as the line always appears above the columns? As it is it appears above in most instances but sometimes appears below the columns.
View 2 Replies View RelatedMake Multiple Charts That Will Graph The Data Of A Specific Name In Column
Aug 5, 2008Is 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
Bridge / Building Blocks - Conditional Formatting In Graphs
Mar 6, 2014Would like to know if it is possible to create a kind of conditional formatting for graphs. I need to work on a graph and when the value is negative the bar changes of color.
Is there any tool or macro code that can do it?
Real Estate Waterfall
Apr 19, 2007I need to create a waterfall structure to analyze a real estate problem. How do I do it?
View 2 Replies View RelatedCreating Revenue Recognition Waterfall
Oct 3, 2008So here's the setup: A customer purchases a service which lasts 6-months. As such, revenue recognition for the company can only occur as the service is provided. So if a person orders a $600 service at the beginning of a month, revenue will be recognized at $100 for the next 6 months. I'm trying to create an Excel Waterfall chart which will show the monthly revenue recognition amounts for all orders depending on the date which they were ordered.
I've attached a sample of what I'm looking to do. It's become tricky for me because Revenue Recognition is pro-rated based on the date ordered (i.e. order on the 20th of a month so at the end of the month 1/3 of the month is recognized as revenue). I'm looking for something that will populate the percentage of the order amount, each month, that will be recognized. I've populated what row 3 should be, but there doesn't seem to be an easy way to apply a formula or something across all cells.
Waterfall Chart - Delete Item
Jan 9, 2007I have a Excel Charts (waterfall graph) which has let us say 10 items in the rows. the first one represents the intial and the last one represents finish. If I want to delete one item in between the first and last, the finish item vanishes. For example I have the following series and I want to delete item G from it. The Finish item vanishes from the graph
Intial200
A100100
B7030
C9020
D5040
G4020
Finish30
Reflect Work In A Waterfall Chart
Jan 2, 2008I am needing to reflect some of my work in a waterfall chart, but do not have that as an option in my list of charts. Is there a down load I can get?
View 2 Replies View RelatedExcel 2010 :: Waterfall And Other Advanced Charting
Apr 19, 2012I was asked to create a Waterfall chart in PowerPoint, which stumped me both in its purpose and how to create it. Is this a standard chart, an add-in, or a chart created by modifying a standard chart?
Two related questions:
What is the best resource (book or web) for advanced charting in Excel/PowerPoint 2010? I just ordered "Charts and Graphs: Microsoft Excel 2010" (MrExcel Library) by Bill Jelen because it had the Waterfall chart in its index. That chart isn't in the "Excel 2010 Bible" or the older "Excel Charts" book by John Walkenbach and is only mentioned briefly in Jelen's "Excel 2010 in Depth."
I'm an advanced Excel user and was wondering whether there are still more charting options in Excel than there are in PowerPoint. I know that used to be the case, but it seems in 2010 that PowerPoint charting has nearly the same functionality as Excel charting or are there charts that are best done in Excel? (...putting aside linking/updating functionality).
Excel 2007 :: Waterfall Chart - Change Color Of Vertical Bar Automatically
May 19, 2012I am building this waterfall chart. I'd like to put conditional color formatting to change the vertical bar automatically e.g. if it is positive, the bar color is green and if it is negative the bar color is red.
View 3 Replies View RelatedConverting Static Charts To Dynamic Charts
Jun 27, 2013My 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.
Pivot Charts Versus Charts
Sep 5, 2012I 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]....
Make Userform Show Data From Spreadsheet And Add Delete Or Make New Entry
Jan 24, 2014I have a spreadsheet on sheet 1 with a list of customers and their information. So on column A I have the customer number (i.e. k968, e37, p528,...), on column B i have the customer's name, on column C the street's name, on Column D the house number, on column E the zip code and finally the city on column F.
Right now there are around 600 customers in this list.
I have made a userform with a combobox in which I want to select an existing customer (pulled from the spreadsheet). On the same userform I have textboxes (customer number, name, street, number, zip, city). When I select a customer in the combobox, I want this customer's info to show up in the textboxes. I want to be able to change the info and hit Next to store the changes in the spreadsheet. When I do not select a customer from the combobox, I want to add new info in the textboxes and hit Next to store this info as a new customer. The userform also has a delete button. Then I select a customer in the combobox, this customer (and it's info) should be deleted from the spreadsheet when i hit Delete. So the spreadsheet is variable in length.
Make Now () = 06/29/2009 (make To Cells With Dates Equal Each Other)
Jun 29, 2009I need to figure a way to make to cells with dates equal each other if the
day,month and year are the same but are placed into a cell at different times during the day. "Making Date Now () = (06/29/09) In another cell". Therefore, A1= Now() and E11 = 06/29/09
PPF Charts
Jan 12, 2010I have never done this before and I am having a hard time - it seems that none of the graphs in the Excel menu accommodate what I want and I have no idea what I am doing to boot.. Could someone PLEASE help?
My data is: American & Japanese workers can each produce 4 cars a year. An American worker can produce 10 tons of grain a yr. / Japanese 5 tons of grain a yr.
Each country has 100 million workers.
Need PPF and Opportunity cost of car & grain from U.S and Japan.
I have at this for two days and I cannot get the information in the chart the way it is supposed to be. It makes no sense evry way I have tried it and the graphs don't even look correct. I've tried several line graphs and scatter graphs..
Updating Charts In 97
May 23, 2008I update graphs/charts everyday. I've been looking at ways of updating a lot of charts in 1 action.....
What would the formula be to have the range of the chart (ie =Data!$BS$1188:$BS$1201) to get the row numbers, not the row, from numbers entered elsewhere on a data sheet (ie =Data!$BS$1188:$BS$1201)
As a lot of the time I use the same number range but on different rows and sheets.
Selecting All Charts
Nov 26, 2008I'm trying to find a way to select all charts in a worksheet and pasting them into a new sheet as a jpeg and can't find a way to select the charts all together as a group like if you shift click them.
I'm looking to copy and paste them as a group because they are grouped in a specific way for a report.
Delete The Charts
Oct 28, 2009I have 2 charts on one sheet. Both the charts are generated using 2 different VBA code. I have also created a Button to trigger the code and generate chart when the button is clicked.
I recently realized that I was creating charts upon charts and was making the excel file bigger in size all the time.
So, I wanted to see if I can delete the individual chart before generating a new one.
Currently, I am using the following code to delete the charts.
XYScatter Charts In VBA
Dec 3, 2009I am having lots of issues with generating a scatter chart in vba. I tried recording a macro but the only thing that recorded was my different selection clicks on the chart. No formatting was recorded. I have the following ....
View 12 Replies View RelatedCharts In 2010
Jan 11, 2010if marco recording of chart manipulation has been reintroduced in XL2010
View 6 Replies View RelatedVBA And Charts In 2007...
Feb 17, 2010I have a piece of code that arranges a chart to fit the data it should show. The code used to work perfectly in the old Excel version, but after an "upgrade" to Excel 2007 I get "Automation Error" from the line where the scale type is set.
View 5 Replies View RelatedAdd-in That CAN Create Big Charts Of 100 X 100
Apr 21, 2013I don't mind paying for the add-on/add-in, I need to have a chart displayed of 100 rows and 1000 cells of data.
View 6 Replies View RelatedDynamic Charts ..
Feb 24, 2007I have a spreadsheet that calculates a value for each age up to 65 on a separate row. I have parameterized the spreadsheet so that depending on the age entered by the user, any row below the age 65 calculation row is blanked out (set to "") with an if statement.
After a new age is entered I would like a line graph to compare the values. My problem is that if I select all of the possible data values (I assume none are less than 20, therefore there are 45 rows of formulas) any rows that have blank values show up in the chart. My data starts in cell A1.
I would like to come up with a macro that accomplishes the following . . .
- determines the number of the lowest row that has a number value in it (since there are formulas below this, Ctrl down does not do this correctly)
- set a named range starting from cell A1 based on x rows (calculated in the prior step) and y rows (constant)
Creating Charts With VBA ..
May 26, 2009I've got a table which has additives in Column A and products on Row 1. There are 13 additives and 10 products. Each combination of product and additive has a price. So I have 130 different prices in my table. The prices change monthly and the new prices are added to the sheet so that last months prices will move to left so that the newest price data table is A1:J13 and previous month is K1:T13 and so on.
I need to make an individual chart to every combination which contains the history of the price changes. I have two cells (A20 and B20) where the user can pick a product and an additive (created a menu by using Data|Validation...). These selections are combined in a cell C20 (=A20&B20). Then I have a macro that is linked to the cell C20 and is basically Case Is = 1st combination --> Call Macro1, Case Is = 2nd combination --> Call Macro2 etc.
That macro will work out just fine, BUT is there any way I could make all the 130 charts easier? Now I've recorded a macro that creates the first chart and then I've just copy-pasted it, changed the attributes (cell numbers, names and so on) that define the data to the next charts. This will take ages...
Every combination will have at least 13 changes (12 monthly price cells and the name of the cart) so in total this will mean about 1500 manual changes. In my case this will mean a high danger of typos.
I know, it would be SO much easier if I could give you the Excel file to look at...hopefully you understood what I mean.
I'll only follow the changes within a year so prices older than a year will not be shown in the charts.
Creating Pie Charts With VBA
Jul 14, 2009Now I need to create multiple pie charts based on data in tables on many sheets.
I need to create the same set of charts, for each sheet separately.
I recorded a macro for one sheet, which created following
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlPie
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).Name = "='GALLERY ON 4TH'!$B$2"
ActiveChart.SeriesCollection(1).Values = "='GALLERY ON 4TH'!$D$6:$D$8"
ActiveChart.SeriesCollection(1).XValues = "='GALLERY ON 4TH'!$A$6:$A$8"
Range("A11").Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlPie
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).Name = "='GALLERY ON 4TH'!$A$6"
ActiveChart.SeriesCollection(1).Values = "='GALLERY ON 4TH'!$B$6:$C$6"
ActiveChart.SeriesCollection(1).XValues = "='GALLERY ON 4TH'!$B$5:$C$5"
ActiveWindow.SmallScroll Down:=3
Range("A11").Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlPie
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).Name = "='GALLERY ON 4TH'!$A$7"
ActiveChart.SeriesCollection(1).Values = "='GALLERY ON 4TH'!$B$7:$C$7"
ActiveChart.SeriesCollection(1).XValues = "='GALLERY ON 4TH'!$B$5:$C$5"
However I cannot automate. I tried different methods for creating the charts, as found on the site [prefer .chartobjects.add(x,y,z,a) since I can immediately position the chart] , but get stuck at seriescollection everytime.
It looks like when the chart is created by XL (with suggested data in it) I cannot address the series data.
I got it right to generate a chartobject that is empty, then added the series data to it, but when opening the new chartobject, it is again populated with suggested data.
How do I generate an empty chartobject everytime, so I can insert seriescollection info with code?
Any other way to generate charts?
Word - Charts
Aug 27, 2009Excel / Word 2003.
I am exploring yet another avenue of vba coding that i am not familiar with.
I have a template word document that i am wanting to fill with items (be it cell values or charts) from an excel file.
I am looking at the coding examples on the net and i am slowly getting there. However i seem to be unable to copy a chart from my excel file and copy into word. I need to be able to specify a specific position on the word document too.
Line Charts
Nov 4, 2009Has anyone seen this problem before;
I used a "MID" formula to extract some data and for some reason the chart I'm trying to use won't recognize the data. Here is a copy of what the data looks like. Non of the vaules will show up on the chart.
DPJE2DD2CE2CJan1.2784.8984.8997.65Feb1.2697.6597.6591.79B10==MID(B$3,8,5)Mar1.3091.7991.79154.7Apr1.28154.7154.7147.6May1.29147.6147.687.78Jun1.4387.7887.78112.6Jul1.39112.6112.6115.2Aug1.42115.2115.293.6 Sep1.3393.6 93.6 138.9Oct1.28138.9138.9NovDec115.6YTD1.32115.6115.6
Charts Won't Update
Jan 12, 2010How do I get my charts to update everytime, the data refreshens...I have my series linked to several worksheets within a workbook.
View 9 Replies View Related