Two lines charts where the lines are of different date ranges?

Get Help
1

I have a chart that looks like this on Excel:

image
image1209×483 63 KB

The orange line is of a date range X to Y; the blue area chart is of a date range A to B. These date ranges do not overlap and I want them to be two separate filters.

Is this possible? My summary is basically to calculate the: COUNT of a category and GROUPED BY the bin ranges (see the x-axis).

Thanks for the help community.

Kind regards,
Christian NW

2

maybe you want to use multi-series chart

3

I can. But both the line charts will both be of different date ranges. Any suggestions as to how I can go about this?