Forum Discussion
Graphing that adds to 100
Good evening. I have a dataset and I need to create a graph like the one attached. The data I have is like this: (target will always be 96%. I need the graph to show the actual and adjustment on one line and then have the months on the x axis)
| Name | Type | Jan | Feb | March | Apr | May | June |
| TMMAL 1 | Actual | 86.0% | 82.3% | 88.7% | 92.9% | 91.6% | 91.5% |
| TMMAL 1 | Adjustment | 86.0% | 95.0% | 90.0% | 94.5% | 91.6% | 91.6% |
| TMMAL 1 | Target | 96% | 96% | 96% | 96% | 96% | 96% |
| TMMAL 2 | Actual | 93.5% | 94.7% | 95.5% | 96.2% | 94.5% | 93.7% |
| TMMAL 2 | Adjustment | 93.5% | 94.7% | 95.8% | 96.4% | 94.5% | 93.7% |
| TMMAL 2 | Target | 96% | 96% | 96% | 96% | 96% | 96% |
1 Reply
This requires a different layout of the data. See the attached sample workbook.
Note that Adjustment is now the difference between Actual and your original Adjustment.
