I'm having a huge problem with a Stacked Column Graph.
The bottom half (red striped) graphs the percentage achieved. The remaining (grey) area graphs the percentage away from 100%.
Basically, this is a thermometer-type graph, showing how close you are to the goal.
The graph works perfectly as long as the percentage is not 83%-99%. At this point, the graph breaks down and becomes innacurate.
I have cut out all "useless" data from these sheets and left only what's needed for this issue. The data is in Sheet 1 and links to the graph in Sheet 2.
The numbers in green (in Sheet 1) are the ones being graphed. The number in blue can be changed to get the desired percentage. If you change the value in blue to anything within the range of $7600 - $9100 you will see the error occur.
ANY help with this would be GREAT!! I have no idea why this is doing this or how to fix it.
Bookmarks