Hi!
I have a set of non-static values that is setup based on certain value criteria:
<tbody>
</tbody>
Basically I have a database, but this table only shows the values of interest. In this case it is to display both columns of data if the number in 'Value 1' exceeds +/- 5%. So as long as the cell in 'Value 1' meets this criteria, the corresponding number in 'value 2' will also be displayed.
However, I would like to graph Name (x-axis) against Value 1 and 2 (Y-axis). And I have a problem because I don't want my x-axis to have the irrelevant data as labels too. In this case, I only need B & C in my x-axis.
But since its a non-static data, i.e. if the criteria was changed, it may be A, C & D that have the table populated while B is blank. Then my x-axis should only have A, C & D.
Is it possible to format my graph such that it is able to adjust the axis according to whether or not there is a corresponding value?
Thanks!!!
I have a set of non-static values that is setup based on certain value criteria:
Name | value 1 | value 2 |
A | - | - |
B | 6% | 3% |
C | -10% | 8% |
D | - | - |
<tbody>
</tbody>
Basically I have a database, but this table only shows the values of interest. In this case it is to display both columns of data if the number in 'Value 1' exceeds +/- 5%. So as long as the cell in 'Value 1' meets this criteria, the corresponding number in 'value 2' will also be displayed.
However, I would like to graph Name (x-axis) against Value 1 and 2 (Y-axis). And I have a problem because I don't want my x-axis to have the irrelevant data as labels too. In this case, I only need B & C in my x-axis.
But since its a non-static data, i.e. if the criteria was changed, it may be A, C & D that have the table populated while B is blank. Then my x-axis should only have A, C & D.
Is it possible to format my graph such that it is able to adjust the axis according to whether or not there is a corresponding value?
Thanks!!!