Hi all,
I have attached an example spreadsheet showing what I am trying to achieve.
Pivot_Dates.xlsx
On the x-axis of the graph I need the dates to be separated proportionally not equally. So a time separation of 12months will appear further apart on the graph than a 6month separation. Forgive me if that isn't clear, it's not easy describing spreadsheets in words! I believe the attached example is quite clear though.
Thank you
Pete
Bookmarks