This content has been marked as final.
Show 2 replies
-
1. Re: Count four sets of dates and plot a running total line graph for each
swaroop.gantela Jun 9, 2016 4:27 PM (in response to Rob Kane)Rob,
Please see if the attached could be a starting point for you.
I think it will help to pivot your dates using:
Pivot Data (from Columns to Rows)
Then it should be easier to plot them together.
If you do need just one of the dates by themselves,
like making the bars for just the Start,
you can try something like:
IF [Pivot field names]="Start"
THEN [Pivot field values]
END
Then you can use the dual axis with lines and bars.
Here's another great resource on lines and bars:
-
208602Late and Early Curves.twbx 44.0 KB
-
-
2. Re: Count four sets of dates and plot a running total line graph for each
Rob Kane Jun 10, 2016 2:47 PM (in response to swaroop.gantela)1 of 1 people found this helpfulThat is brilliant thank you so much for the help. I have not explored the pivot options so will have a good look this wekend and thanks too for the additional link.