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
ADVERTISEMENT
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
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 RelatedAdd Data Monthly And Then Have To Manually Update The "source Data" To Reflect The Added Data On Chart
Apr 28, 2009I have a column line chart to which I add data monthly and then have to manually update the "source data" to reflect the added data on chart. This is a rolling graph, which mean that I have to remove data for one month(from last year) and then include the new month's data. Is there any way on automating this process...like a macro or something, so once I add the data excel automatically removes one month of old data and make changes to include fresh data. Eg Currently chart is based on data from A2:F2 and I add new data to cell G2. I need something which automatically update the source data to cell B2:G2.
View 4 Replies View RelatedHow To Get A Chart To Work With Irregular Dates Correctly
Jan 3, 2014I've tried for some time now to create a chart where the x-axis make up for irregular dates. Making the line between 2 points longer if it's long time between them and short if it's short time between them.
I've finally understood line charts doesn't support that and I have to use scatter graph. It seems to work but the dates, the get all messed up. I type 2014-11-11 but the x-axis in the graph shows 2283-12-12 or something like that.
Got a notion that I might have to transform it to the date value manually first but I get #VALUE ERROR
i.e. 2014-11-11 in A1, then I type in A2 =DATEVALUE(A1).
How do I get a chart to work with irregular dates correctly?
Show & Chart Shift Work Patterns
Feb 27, 2009Split from How To Set Up A Spreadsheet The Right Way
Taking onboard what you suggested I have "rethought" the layout and it is now in a single table format. What had stopped me doing this previously was the fact that I was not able to show 7 days a week for 48 weeks in columns. However thanks to the transpose function all the data is now more user friendly (See Attached Workbook)
You mention the data should be quite easy to manipulate from here, any ideas as I am struggling with the concept of how to display the data in a time series. I assume that it will involve some form of lookup function referenced to the table of times, but thats as far as i can get.
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 RelatedHow To Make Bridge Charts Waterfall
Feb 4, 2014I have a data and did not know how to create a bridge charts.
View 1 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.
ActiveX Listbox Does Not Work With VBA Code For Changing Chart Axis Scale?
Jun 5, 2014I have some code for changing the scale of my chart axes so that when new data is inserted into the column which the chart sources from (say column B), the axis scales on my chart will automatically adjust (as the Excel algorithm sometimes leads to charts which are a bit squashed). This code works fine, and I have included it below.
I have then tried to introduce an ActiveX listbox so that when you select an item in the box, the reference number generated (1,2,3...etc) then determines which data series is inserted into column B using a vlookup function. However, when I do this, the original VBA code for automatically adjusting the chart axes no longer works.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
With ActiveSheet.ChartObjects(1).Chart
[Code].....
Excel 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 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).
Formula That Will Reflect A % Value Within That Range
Oct 18, 2008How can I create a formula that will reflect a % value within that range?
(Example)
Input cell = 129 this value can be changed between 0 and 800
A1 = 0
A2 = 800
(Range) 0 to 800 = 100%
What would the percent value equal?
Conditional Formatting To Reflect 2 Outcomes?
Mar 3, 2014I have a master worksheet with due dates for various forms to be completed. These forms are on separate worksheets within the workbook.
I'd like to highlight the master date entry in red if the form hasn't been completed by the due date, but also highlight in green when it has been done.
How To Make A Cell Reflect Workbook Name
Mar 9, 2014I've seen it done, and had the formula on a couple documents, but had a loss of data. What I'm looking for is the formula to enter into a cell for copying the name of the worksheet into that cell.
View 6 Replies View RelatedSum Function To Reflect Results Across Sheets
Aug 4, 2014I am trying to sum the details from sheet2 in sheet3. I am currently using a plain formula to sum-up the values. However, create a indirect and vlookup function to sum the values.
In sheet3, I have to sum the values from sheet2 based on the contacts. Sheet1, sheet2 and Sheet3 are connected and any update(insert,delete.. etc) will be made in sheet 1 only. Sheet2 automatically updates based on sheet1. Similarly, Sheet3 should also update based on sheet1 and sum the values based on contacts from sheet2.
I have added the formula which I am currently using in the sheet.
Changing Data On One Sheet To Reflect Changes On Another?
Jul 1, 2013My goal is to have changes done to one sheet reflect on to another to make things much more easy to do. Below is a picture of what I am dealing with. ( I covered some personal information)
pic of excel.jpg I want to be able to plug in something or delete it and have it reflect to all other sheets. Also I would like to be able to plug in some information and have it export itself based on a specific information. For example, I would want all Newark,NJ contacts to be place in the Newark list automatically.
Updated The File Name Changes To Reflect The Revision
Mar 17, 2009I have a spreadsheet that references another spreadsheet, however the other spreadsheet will get updated from time to time. When it's updated the file name changes to reflect the revision:
"C:Projects9-022_Tunisia1_Design9-022-R00-Inst_Database.xls"
When this file is revised the "...R001..." will increment with each revision but the rest of the file will stay the same.
Sometimes I have to reference a file in another directory:
"C:Projects9-030_Brazil1 Design9-030-R00-Inst_Database.xls"
I was planning on placing information in the following cells of this spreadsheet ("C:Projects9-022_Tunisia1_Design9-022-R001-Cause_&_Effects.xls):
Cell A1 - Project Number (i.e. 09-022, or 09-030)
Cell A2 - Project Name (i.e. Tunisia, or Brazil)
Cell A3 - File Rev Number (i.e. 1, 2, 3, etc.)
I was thinking my "INDIRECT.EXE" would look something like this:
=INDIRECT.EXE("'C:Projects"&A1&"1_Design["&A1&"_"&A2&"-R00"&A3&"-Cause_&_Effects.XLS]Index'!Q5")
The value on the spreadsheet tab "Index" that I'm referencing in cell Q5, is "FG-5901" but all I'm getting in the spreadsheet were this formula resides, is an error "#NAME?"
Part of my problem is that I don't fully understand the function of the "&" symbol in the formula. Sometimes I've seen it placed on both sides of a cell reference (i.e. &A1&), and other time only at the being (i.e. &A1).
Reflect Changes Done To One Google Sheet Workbook On Another One
Jun 16, 2014I have two different Google Sheets Workbooks;
I need that for ie: changes made on C3 of Workbook 1, reflect on E23 of Workbook 2.
Adjusting Charts To Reflect Data Properly
Feb 2, 2009I've compiled data into a spreadsheet which indicates the number of homes sold over the course of 3 years (from 1/1/05 to now) along with their price per square foot, sale price, year built, bed/bath count, and other pertinent factors regarding each property.
I've extrapolated graphs from these in the past which indicated the trends in each category over time (i.e.: Average quarterly price per square foot over time, and so forth).
The data range I'm working with now, however, is from an area of my region so small, that the number of units sold over the past few years is sporadic. Whereas it's normally 100 to 1000 units that comprise my data, now it's only 15 units.
This has created gaps in my line graphs where the price per square foot will dramatically drop down to zero over the periods in time where no sale was recorded. So the line graph ends up looking like a zig-zaggy range of peaks reflecting the price per square foot of a sale, and valleys representing "$0.00" for periods of time where nothing has sold.
To have a Price per square foot of $0.00 is incorrect since in reality nothing was sold.
I would like to be able to eliminate the portions of the graph that have the "$0.00" so that the line graph can "jump" from one sale to the next when the quarterly data indicates 0 units sold.
I'd like to do this without having to eliminate those areas in my spreadsheets. Is there any "catch-all" tool that might do this or is that just crazy talk?
Sumif (change Cells To Reflect New Costs)
Nov 18, 2009I need to change cells to reflect new costs. Then have these costs roll into new totals. I attached a worksheet to demonstrate how it works. The numbers in gray should be adjustable. The numbers in tan are summing up incorrectly with my "SUMIF" formula.
View 2 Replies View RelatedHlookup: Capture The First Instance Of A Value(ie 1) And Reflect The Top Row Of The Value (date)
Nov 19, 2009Im trying to capture the first instance of a value(ie 1) and reflect the top row of the value (date). I cant seem to make Hlookup work. I got it to work on the first line using index and match, but when i tried to copy it on the succeeding cells, it gives me the wrong data.
I also tried the following
StartedDate started1-Dec2-Dec3-Dec4-Dec5-Dec6-Dec7-Dec8-Dec9-Dec10-Dec
aaaaaaayes12/1/200911
bbbbbbyes1/0/1900111
b2b2b2b2b2b2no
ccccccccyes111
Change Formulas To Reflect New Sheet Title?
Apr 7, 2014I have a workbook, everyday 2 new worksheets get added to reflect the previous day's work. How can I reflect in a formula to go to next sheet instead of the conventional naming 'Sheet1' G7?
View 6 Replies View RelatedAvergaes Points (reflect By Lines) To Start
Nov 15, 2007I have a chart with 8 series of data, 4 of which reflect actuals and 4 of which relates to averages of the 4 actuals of a period of 5 months.
The 4 actuals series are represented by bars on the chart and the 4 averages are represented by lines on the graph.
When viewing the chart it shows 4 bars per period (for each of the actuals) and 4 lines (for each of the averages per period)
How do I get the avergaes points (reflect by lines) to start above the actuals they are averaging? At the moment the points are bang in the middle of the 4 bars in the chart?
Not sure if I have explained my problem preoperly but if not I can email a file showing what I mean if needs be.
Refresh Master Sheet To Reflect Changes In Other Sheets
Apr 29, 2008I am running a macro to create a combined master summary sheet from data in several other sheets contained in one workbook. That is working fine. I need to create some kind of refresh macro so that when data in these sheets change the master sheet will change and update automatically.
View 9 Replies View RelatedTo Collect Data From A Darts Team And These Values Reflect
Jul 4, 2006I am trying to collect data from a darts team and these values reflect
the number of points won in a team game (ranging from 0 - 3). This will
probably be simple for the experts here, so I'll let fly:
I have a table with six names across the top. In the rows below there
will always be two cells that have number values ranging from 0 - 3
while the rest will be blank. Those two numbers however, will always be
the same. I am trying to write a formula that will determine which
columns have values and return a single letter value (first initial)
for each name. Since all the names are different that is not an issue...
RowSource To Reflect Data Added To Named Range
Nov 8, 2006I have several ComboBoxes & ListBoxes on a Userform that populate by referring to Dynamic Named Range in the RowSource property. Also on the Userform is an area to edit/add/delete items in these named ranges. If I Add or Delete an item, the Named Range does not automatically resize--or at least the Menus don't "resize" accordingly--unless I unload the UserForm and load it back up. Is there a way to refresh these Comboboxes without reloading the UserForm?
View 2 Replies View RelatedIndirect: Reflect The Data In The Active Sheet Or Give Me A #VALUE Error
Jan 16, 2009I am running the formula =VALUE(RIGHT(CELL("filename"),15)) to read the tab name in a workbook with 90 sheets. When a new account is opened, the operator inserts a new sheet from a template (which contains the above formula), and labels the tab to the account number. The formula then 'reads' in the account number and performs look-ups based on it.
The problem is that the sheets are only working when the sheet is active. They all seem to reflect the data in the active sheet or give me a #VALUE error. Where am I going wrong? How do I fix the problem?
Work Out A Formula For My Spreadsheet Which I Use To Work Out Cutting Lists For Timber Frames
Jan 11, 2009i need to work out a formula for my spreadsheet which I use to work out cutting lists for timber frames. I need it to work out if the width of a job is for eg 2400mm i need to work out how many timber studs I need so the space between each stud is between 400mm and 500mm and this will need to work for a range of different sizes of frames. I have it written at the moment and it just devides the width by 400 and gives me a amount of studs but it would work much better if it could space them between 400 & 500.
View 4 Replies View RelatedWork Accurately With Times To Calculate The Work Progress Of The People In The Workshop
Mar 3, 2009In a project i am compiling i need to work accurately with times to calculate the work progress of the people in the workshop thus....here goes....
I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected.
From monday to friday the workmen log their times as a start time and a end time. This has to be then calculated to a total hours:mins spent per job, wich in turn then has to be calculated to a total hours:mins spent per day. And the on the complete week sheet recalculated as a total time worked per week.