• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Project Timeline

    I agree with Luke M's side note. Convention states that you put the independent variable (time) on the x axis and the dependent variable (milestones) on the y axis.
  2. K

    Show legend only when series is selected.

    I have used the options shown in this website to have graphs that show when a box is checked. Problem is that excel legend does not change accordingly. Example persons can check whether they want to see a trendline or the target figures. If the tick box for target is unchecked, excel still has...
  3. K

    Option of showing forecast on graph

    Anupagarwal06: Yes thsi is what I wanted to do but with a aslight modification. I see what you did to calculate the forecast figures, but how can I get the same thing using a named range. The nature of my spreadsheet does not allow me to add another column. I am thinking of replacing the cell...
  4. K

    How to calculate growth rates using dynamic name ranges

    Daffy333, It works perfectly. Thanks a great deal. Thanks guys
  5. K

    Option of showing forecast on graph

    Anupagarwal06: When I try accessing the file I get the following message. "This item might have been deleted, expired, or you might not have permission to access it. Contact the owner of this item for more information." Do you know why this is happening?
  6. K

    How to calculate growth rates using dynamic name ranges

    The named range I currently have is the raw data NOT the growth rate. What I want to do is create a named range for the Growth rates.
  7. K

    How to calculate growth rates using dynamic name ranges

    Narayan, I saw your file, but it's not quite what I wanted. The mathematics is correct, but I do not want to have to create a new series with the calculations. So imagine that my worksheet can only have one data series which is the actual values. I do not want to do the growth rate calculations...
  8. K

    How to calculate growth rates using dynamic name ranges

    Narayank991 that is correct. How did you get it to work? Can you share your file?
  9. K

    Option of showing forecast on graph

    Thanks Hui. The problem now is linking both the actual and forecast lines together. I see where you assisted someone with this problem, but the solutions that were given wont work in my case, as i use only dynamic ranges in my dashboard. so I see where the option was to have the last value in...
  10. K

    Option of showing forecast on graph

    I'm searching the posts on this website for anything dealing with dynamic graphs with forecast values. I want the graph to always show the actual figures, but I want to enhance it by allowing users to be able to select the option of showing the next 3 month's forecast figures. Does any one know...
  11. K

    How to calculate growth rates using dynamic name ranges

    Mike I used your formula but it's not working. I've sent you a link to teh file. Can you tell me what I'm doing wrong? https://skydrive.live.com/redir.aspx?cid=16d0ed9ee1cb5b75&resid=16D0ED9EE1CB5B75!102&authkey=LyNV5hQzjSk%24
  12. K

    How to calculate growth rates using dynamic name ranges

    Mike, thanks for your response, but I think I need to explain some more using an example. Lets say the data for Y_Axis is as follows: 1 4 9 15 Then the first growth rate is (4-1)/1 = 3% the second is (9-4)/4)=125% etc, so its always (new-old)/old.
  13. K

    How to calculate growth rates using dynamic name ranges

    Forgot to mention I want month to month growth rates
  14. K

    How to calculate growth rates using dynamic name ranges

    My dashboard tracks monthly KPI data. I have a dynamic chart which changes based on the months selected. What I want to do is add a series showing the growth rate over the period. I know how to make the chart dynamic what I don't know is how to calculate the growth rates using name ranges. The...
  15. K

    Forecasting KPI in Dashboard

    Thanks Jeremy. That's what I think too but they are insisting on me applying a statistical technique to forecast these KPIs which are sooo wide ranging. I have a few ideas though will decide on one to use. The second problem is my company isn't too big on data, you have to pull an arm and leg to...
  16. K

    Interactive Charts PPT Slide Show

    I don't think the interactive options would work outside of excel.
  17. K

    Forecasting KPI in Dashboard

    For those who create dashboards for their organizations, I wanted to know what forecasting techniques available in excel do you use to forecast your KPIs. Or is it that in your dashboards you do not report forecast figures?
  18. K

    Dynamic Exponential Smoothing Formula

    I have a dashboard where I forecast KPIs for the coming month. I have decided that exponential smoothing is the best forecasting technique to use. Problem is exponential smoothing provided by Excel in Data Analysis is not dynamic. Hence when I select the various KPI it is not updated. Without...
  19. K

    Add every other column

    Thanks. It works.
  20. K

    Add every other column

    I have a spreadsheet with actual and budget figures for various departments. Values are from Column C to V. So this is what I want to do: Add all the actual figures in columns C,E,G,I,K,M,O,Q,S,U Add all the budget figures in columns D,F,H,J,L,N,P,R,T,V What is the formula to add every...
  21. K

    Calculate percentage of target achieved when target is a negative number

    Thanks for the feedback. I'll make adjustenmnst accordingly. Luke M. Can you expound more on the column that you include for goal listing?
  22. K

    Calculate percentage of target achieved when target is a negative number

    Here is my concern with this calculation. Say target is 4 and you get 4. Using this formula you would have (4-4)/4 = 0 I have 2 other challenges: 1. What if the target is 0? Excel shows error as is expected. How do you guys get around this. The KPI is number of accidents. Should I reword...
  23. K

    Calculate percentage of target achieved when target is a negative number

    Hui how would you interpret that figure?
  24. K

    Calculate percentage of target achieved when target is a negative number

    In my dashboard I report on percentage of target achieved. Its calculated as (actual/target)*100. My problem is that some of the targets are actually negative. So if you had target of -2 and the actual was 4 the calculation will be -200%. This is incorrect as it should be -300%. I plan on using...
  25. K

    How to calculate r squared

    Yep that did teh trick. Thank you very much. I searcehd the list of formulas and some how did not see rsq...go figure. It may seem strange taht I want to add a trend line option and then tell users whether it follows a trend or not, but persons tend to report graphs with linear trend line even...
Back
Top