LinkedIn
Twitter
Is there a way to format this so the lines "stick" to their column?
Left Y-axis = a metric I am tracking
Right Y-axis = that metric as a % of some individualized target
X-axis = date dimension
The three violet columns represent different items I am tracking. I am comparing them against each other every day.
I also want to visualize how each day compares to a specific target for each item. For this I calculated the % and am displaying it as a line. However the lines stack on-top of eachother instead of aligning with their respective columns.
[Black line > Dark violet] [Orange line > Medium violet] [Red line > Light violet]
Note, there are multiple items that can be picked in this dashboard so I need it to dynamically update and not break when a new item is picked.
I am open to displaying this information in a different way such as: https://www.highcharts.com/demo/highcharts/column-placement but haven't been able to make this work yet either.
The data structure is pivoted by item as sketched below.
I appreciate any thoughts or advice!
