I am hoping for some help taking the dynamic charting one step further. I'm familiar with creating dynamic charts, but I'm stumped as to how I can do the following:
I am pulling in Bloomberg data into an ever expanding data set called TABLE A. What this means is that there is one formula, and that one formula generates a table that is four columns wide and "X" rows tall. Every five minutes, new data points are added to the table. Let's say, for example, that the maximum amount of rows is 400. Take note that the minimum amount is one.
From the table, I'm creating another table (TABLE B) that is calculating percentage changes from TABLE A. Then, I need to put the percentage changes into a graph. This is where I need help.
Is there a way to create a dynamic graph that will only graph integers? Thus, when another integer row is added to TABLE B, I'd like the chart to graph that. I wrote the formulas in TABLE B to display #N/A (using NA() ), and I'd like the graph to not show those values along the x-axis. What happens now is that while the line graphs end, there is still a significant amount of space after the end of the line graph. It would be great if there was a formula where the unused cells were empty, but it doesn't appear I can do that (" " is still recognized as text).
Thanks in advance!
I am pulling in Bloomberg data into an ever expanding data set called TABLE A. What this means is that there is one formula, and that one formula generates a table that is four columns wide and "X" rows tall. Every five minutes, new data points are added to the table. Let's say, for example, that the maximum amount of rows is 400. Take note that the minimum amount is one.
From the table, I'm creating another table (TABLE B) that is calculating percentage changes from TABLE A. Then, I need to put the percentage changes into a graph. This is where I need help.
Is there a way to create a dynamic graph that will only graph integers? Thus, when another integer row is added to TABLE B, I'd like the chart to graph that. I wrote the formulas in TABLE B to display #N/A (using NA() ), and I'd like the graph to not show those values along the x-axis. What happens now is that while the line graphs end, there is still a significant amount of space after the end of the line graph. It would be great if there was a formula where the unused cells were empty, but it doesn't appear I can do that (" " is still recognized as text).
Thanks in advance!
