Make a graph of timeserisdata with different time-intervals (year/month)

@hpdm, format axis as text

@droppe, post workbook example (if above suggestion does not work)

Thanks for replying! Actually, i think maybe my problem is the opposite of hpdm's. I want to make the intervalls in the graph to be equal in time so that the distance betwwen may and april is a twelfth of the distance between 2010 and 2011. One problem is my x axis data is organised as text (quarters of years and months).

I attached a snaphot of the data i'm working with.

Someone suggested i just need to make the whole timeseries monthly (adding 11 new rows each year that is only a year, and so on), then it's easy to make a non-skewed graph from it. I suppose it would work. But. It just can't possibly be the smartest way to do all that work by hand?

And what if i want to add another timeseries from the same source, configured in the same way (for instance, maybe i realise i want to compare the amount of debt to banks by both housholds and companies).

I imagine something that tells the graph the distance between the data points in the x-axis changes at two times in the series. Or some way to make a macro that makes the right amount of new rows in the right places, so that i don't have to do it by hand - it's a long series...

In order to plot time series you need actual dates.

See difference between plots for a few of the data points.

Oh, i didn't know you could do that. Smart!

But the easiest way to do make the series into dats can't possible be to re-write every entry so it matches excels imagination of what a date is? Or? Hmm.

unless you have a valid date how would you expect excel to treat random text?

How can that work, unless you real data is very different from example?

If you processes blocks of your data then I see how that is working.
I had wrongly assumed you entered the first date and them fill down ALL data items.

Select axis and display format dialog.
Axis as Time series, rather than automatic.