Instead of removing the last bar, would I be able to change the color of just that bar? I found a way to do this, but it changes all the others to the same color.
I think you may be using Measure Names/Measure Values to generate your chart?
If so, I think it will be difficult to pick out just one bar (Index values won't work
over Measure Names).
One potential way to address this will be to make a data scaffold
which is simply a single column with your two Measure Names:
The methods to use this are described here:
But if I am completely off base with this, please post a screenshot
of your worksheet showing the location of the pills on the shelf.