Period Comparison on a chart using Calendar Objects

[Anonymous]

Hello All,

Im trying to compare the trend of a metric, on a line chart, across 2 different time periods.

The x axis will have dates and the y-axis will have the metric.

The issues that im trying to resolve are the following:

1. When i select 2 date periods, with "the same" number of days, from the object calendars i would like to see 2 lines on the chart, one below the other, and not one next to the other (see image below)
2. When i select 2 date periods, with "different" number of days, from the object calendars i would like to see 2 lines on the chart, one below the other, where the start dates from both date periods will be in the same vertical line (start from the same point in x axis)

This may require some VB programming code. Any help will be much appreciated.