Forum Discussion

GBKYE2's avatar
GBKYE2
Frequent Visitor
4 years ago
Solved

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

A100
B53
C15
D80
E0.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!

2 Replies