LinkBack URL
About LinkBacks
hi everyone,
In the graphic attchament I would like the label for the last entry goes automatic to last entry. In the example the label is on June but July have already a value. How can the label goes automatic to July ??
thanks for your help.
hi everyone,
In the graphic attchament I would like the label for the last entry goes automatic to last entry. In the example the label is on June but July have already a value. How can the label goes automatic to July ??
thanks for your help.
In the process of working this out, I somehow destroyed the X-Axis. It shows only every other month.
What I did was create a second series. Cells E37:G38 contain the calculations.
Cell G37 has the formula: =MATCH(TRUE,ISNUMBER($Z$6:$Z$143),1) - this is entered as an array formula.
This cell essentially looks for the value TRUE from the bottom up. TRUE first appears where there is a number instead of N/A - In this case it is found in row 109 of the data (which is physical row 114) - This is what makes the formula dynamic.
Cell G38 has the formula =INDEX($Z$6:$Z$143,G37,1) - this formula gets the value associated with this row number
This information is entered as a second series (X-Y Scatter Plot) in the chart as shown in the image.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thanks for your help. I try do make what you tell me but I have a problem to make the serie with X and Y. When I tell to make a new Serie only open "Series name" and "Serie X values". What I must do to appear also Series Y Values ?
thanks again.
Thanks again for your help.
I make it as you tell and Works !
But in the example I send you with a graph with 2 different values (1 e 2) , when I try to add a new value for values 2 it comes with the Serie X and Y and I just want with the X to selet the values. SOmetimes is need to have X and Y another times is only need the X. How can we open with both or only the X ???
My problem is select in "2" the values because appers the Y also.
I am not sure I understand the question. All I did in the following is add the data label.
If you want it offset with the leader line, I'll have to add some VB code to accomplish this.
Also, I have some unused calculations, you can get rid of these. They are Year, Row Number and X.
Thanks again for your help.
In the Sheet You send ( Livro123C) as you see I have the Values (AC10:AC82) for the line Blue (register 1) and the label of the last value with my format. (register 1 Mes).
You add the (Register 2) but not show the line with the values (AH10:AH82). This is the problem!
Then you add the (register 2 Mes) for the label and is ok.
The diference between Register 1 (is ok) and register 2 (Don't appear) is if you select register 1 just ask you for the name of the Serie and the values for the serie. If you select register 2 it will ask you for the name of the serie, the Values of "X" and the values for the "Y". What I can do when I select register 2 to ask me Only the name and the values, like in 1 ??
Hope you can undestand my qestion and 1 more time thanks for your help.
Thanks again for your help.
In the Sheet You send ( Livro123C) as you see I have the Values (AC10:AC82) for the line Blue (register 1) and the label of the last value with my format. (register 1 Mes).
You add the (Register 2) but not show the line with the values (AH10:AH82). This is the problem!
Then you add the (register 2 Mes) for the label and is ok.
The diference between Register 1 (is ok) and register 2 (Don't appear) is if you select register 1 just ask you for the name of the Serie and the values for the serie. If you select register 2 it will ask you for the name of the serie, the Values of "X" and the values for the "Y". What I can do when I select register 2 to ask me Only the name and the values, like in 1 ??
Hope you can undestand my qestion and 1 more time thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks