I have a simple table composed of two columns (Value 1 and Value 2) of numeric data (range 0.0 to 6.0). I've attempted to build a HORIZONTAL STACKED BAR CHART that shows the level of Value 1 and the difference withl Value 2. If Value 1 = "n/a" then it is considered not selected as a value to display.
Here is what I'm looking for;
The simple part:
1.) The horizontal axis needs to be reversed so that Text A (and associated values) is at the top.
2.) I need to have the horizontal axis reflect the words "Stage 1", "Stage 2", "Stage 3", "Stage 4", "Stage 5" as text appearing between the 1 - 5 ticks in the axis.
And this is the hard part;
3.) If the value in value 1 = "n/a" then the row needs to be removed from the graph with the graph reajusting to only show those rows with value (i.e. if value 1 <> "n/a" and value 1 or value 2 > 0, then display values.
Much thanks in advance,