I have a graph that displays daily production. There are 2 shifts a day, so the graph has 14 different data points. There is also a constant target line.
Since the graph gets updated twice per day (at the end of each shift) I want to add a column graph on the right hand side showing the total production compared to the target. For example, if I have a target of 5 every shift, the total target for the week is 5*14 = 70. And if so far I have produced 4 and 2 on the first day and 5 and 3 on the second day, the total produced is 4+2+5+3 = 14. I want to add a column graph on the right side on a secondary axis showing the two values (14 and 70).
Any idea how to do this?
I attached a picture of the graph I have now.
Thanks.
Bookmarks