Hi.

I want to make a graph of some timeseriesdata. The problem is the data is in different timeintervalls - part of the series is data for every year, some is every quarter of a year and some is every month. Now if i just make a graph of this excel thinks it is as long intervall between the months as the years and hence the graph becomes quite skewed. How can i make it be representative of the data?

My first thought is to make an new coloumn where the time-series is in only yearly data. But this would be crazy much work by hand. It just can't be the easiset way.. so any other ideas would be appricieated!

/ Åsa