Bar Chart - side-by-side comparison of category average and individual item?
I'm interested in building the following type of graphic.
Let's say I have a category such as 'Truck' and want to calculate the average cost for all categories 'Truck'.
And let's say I would like to have a side-by-side comparison of that average compared to a particular 'Truck'.
I'm having a tough time achieving this without hardcoding values.
Any advice would be appreciated.