1 of 1 people found this helpful
I din't know putting 0 on the column with date will work as place holder.
I played around couple of hours but this default setting cannot be controlled.
So I finally gave up and took different appraoch.
You may already tried this one, but just as FYI.
It was quite difficult to replicate data itself, so I created simplified data instead.
Only want to show limited column number does not impact to length of date range.
The disadvantage of this approach is that because data is duplicated, all the KPI calc need to consider table name.
I used union to duplicate data source.
2 of 2 people found this helpful
You're using the workbook by Robert Rouse :
With Robert's permission I'm going to make slight modifications:
-- making 0.0 and Date a Dual Axis and manually "synchronising axes"
(by either fixing ranges or using invisible Reference Lines -- I do both).
Please find the attached.
Thank you so much for the advice and time spent on this! I didn’t even think of synchronizing both as a dual axis would do the trick.