I am trying to finish a dashboard but I’m having trouble with one piece.
We have been using Excel and PowerPoint for last 5 years but we’re having to spend countless hours trying to get the graph the way it looks. The idea here is to compare two different dates and determine if there were any improvements in the Lines Handled Per Hour and/or Errors/1,000 Lines Shipped.
-Green arrow means they both improved.
-Black arrow means either Lines or Errors.
-Red arrow means they were no improvements.
To get this graph to look the way it does, I have to manually drag the arrows and connect the dots from the previous dates. The problem is that it takes too much time to do it, (about 6 hours a month since there are 10 slides to this presentation.
I have been able to replicate the same graph in Tableau using the DATE as the Path of the Line (Please see Lines vs. Quality Improvements sheet on the attached workbook). The problem that I have encountered is the COLOR of the line/lines. I want to be able to select different dates and the color of the Lines to change from one previous date to a current date depending on the improment like the PowerPoint. I have attached a copy of the Workbook and the Excel file for you to take a look at the sheet Lines vs. Quality Improvements to see if there is a way to do this. This will show what direction each facility is going from month to another. Please take a look the workbook and let me know if there is anything you can do to help.
THANK YOU VERY MUCH