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...
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...
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)?
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...
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...
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...
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...
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
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.
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...
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
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.
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...
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...