Problem with have a chart with different data ranges
Hello everyone, I have a chart in excel that I have some financial data for some companies, some of data, for example cash flows are from July 2014 to June 2015 and each month has one data point, also there is another series that is related to a 3 months period, the data for that period is daily for the first 10 days of September and from that time to end of November they are weekly, how can I depict the second series in a chart that is ranged from July to June and then have a second series that starts from September(or August) and finishes in the November? Attached is an illustration of what I need.
|