• 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

    How to calculate r squared

    I have monthly data which I am trying to analyse in a dashboard. One idea I have is to give users options to add a linear trend line to a graph I created. However i want to write a statement stating whether the data follows a linear trend or not. I know how to write the statement, what I don't...
  2. K

    Formula to return first or last value in a range

    Thanks Luke M it worked like a charm. I see persons constantly using this INDEX formula, I didn't understand it's use until now. Thanks again.
  3. K

    Formula to return first or last value in a range

    No not teh largest or smallest. Let me give an exam. let teh name range Y_Axis contain the following numbers listed in a column: 4 6 7 8 9 0 2 3. I want one formula that will look within the range and give me the first value which is 4 and another formula to look within the same range...
  4. K

    Formula to return first or last value in a range

    I have a named range which I called (Y_Axis). I want to use the first and last values within this range for something. So my question is: Is there a formula which will look within the Y_Axis range and give me the first or last value (depending on which one I want)?
  5. K

    Writing inequality equations

    Thank you vaskov 17 and OleMiss2010. Formulas worked. I used OleMiss2010's suggestion as I think another level may be included. Thanks again guys.
  6. K

    Writing inequality equations

    I want to do the following: If the score is equal to or greater than 0.75 the word "Well Done" is to appear, 0.5 - 0.74 the words "Good Effort" must appear and if the score is less than 0.5 the words "Needs Imrovement" must appear. Does anyone know how to write this inequality. The one I have...
  7. K

    Dashboard with KPI using Balanced Score Card

    Thanks for the feedback. I'm currently revamping the file. I should be finished this week. It will give you a better understanding of what I'm working with. To address some of your questions. There is an input worksheetsheet where users go to to manually enter the data. The files are on a shared...
  8. K

    Dashboard with KPI using Balanced Score Card

    I viewed the dashboards from this website. They are really nice and I've incorporate some of their ideas. The challenge I'm having is that my Organization utilizes the balanced score card. Each Division has its own KPI. For the individual Division dashboards my supervisor wants to be able to...
  9. K

    Why would a MATCH formula not work?

    Wow! Works, beautifully. I didn't know about the INDEX formula. Thanks Chandoo.
  10. K

    Why would a MATCH formula not work?

    The table looks like this: A B 1 Quarter Actual 2 Q1 1,677,106.7 3 Q2 1,914,202.2 4 Q3 1,231,181.3 5 Q4 1,563,159.6 I then ask excel to give me the minimum value using : MIN(B2:B5). The answer is in cell B11 I then want excel to tell me the...
  11. K

    KPI Dashboard

    I had used this website to get an idea for the formatting of my dashboard and how I could represent the data. http://www.idashboards.com/Pages/Live-Dashboard-Previews.aspx
  12. K

    How to set X and Y Intercept to zero in graphs

    Wow. You most definitely are an excel ninja :)Thank you, thank you, thank you. I have been battling with this for months. It works beautifully. Thank you again.
  13. K

    How to set X and Y Intercept to zero in graphs

    Oh in response to your question. Yes I'm refering to that bullet graph.
  14. K

    How to set X and Y Intercept to zero in graphs

    For instance, when you select Income Kingston Beach, the graph starts at 8 million, instead of zero, this gives the impression that the target is far from the actual. If you change the numbers to negative (as I just did) the graph starts at -8 million instead of zero. I want the graph to...
  15. K

    How to set X and Y Intercept to zero in graphs

    I think this link should work. https://skydrive.live.com/redir.aspx?cid=16d0ed9ee1cb5b75&resid=16D0ED9EE1CB5B75!102&authkey=LyNV5hQzjSk%24 The graph is on the worksheet named "Dashboard" It plots actual and target figures
  16. K

    How to set X and Y Intercept to zero in graphs

    See file here https://skydrive.live.com/?cid=16d0ed9ee1cb5b75&sc=documents&id=16D0ED9EE1CB5B75!102 I'm new to this, so let me know if the link doesn't work.
  17. K

    How to set X and Y Intercept to zero in graphs

    Thank you for the warm welcome. The data is in different columns (if that's what you mean by quadrant). I had a graph for each variable but it was overwhelming. (I have 20 variables to plot). A suggestion was made to have one graph where the user would select which variable they want to see, do...
  18. K

    How to set X and Y Intercept to zero in graphs

    Hi. My challenge is that I have a dynamic graph that plots positive and negative numbers. I want to force the graph to have 0 as the point of origin (whether its plotting positive or negative numbers), without having to use VBA. I get the impression that this is impossible. I cannot tell it...
Back
Top