-
1. Re: Count four sets of dates and plot a running total line graph for each
1 of 1 people found this helpfulRob,
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:
Bars and Lines | Drawing with Numbers
-
2. Re: Count four sets of dates and plot a running total line graph for each
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.
