Forum Discussion
Visualizing Potential vs Actual
Hi all,
I'm trying to make a chart showing actual vs potential value for say a specific month, for e.g. this dataset:
NamePotentialActual
| A | 10 | 0 |
| B | 5 | 3 |
| C | 1 | 5 |
| D | 8 | 0 |
| E | 0.5 | 0 |
I'm trying to show how each product actually performed against its predicted potential.
Line charts are out since this isn't a series so I started with some bar/waterfall charts but I couldn't really get those to show the information in a meaningful way since some actuals can be above or below potentials. I also tried using some candlestick charts to visualise but the ones I could find did not work the way I thought it would and requried more data points such as close/open values which I do not have.
Does anyone have any suggestions? Thanks!
Hi GBKYE2 ,
Maybe you can try Bullet Chart with Custom Label Placement to compare two values.
Or Linear Gauge by MAQ Software
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- v-chenwuz-msftCommunity Support
Hi GBKYE2 ,
Maybe you can try Bullet Chart with Custom Label Placement to compare two values.
Or Linear Gauge by MAQ Software
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- GBKYE2Frequent Visitor
I will give those a try, thank you!