I am creating charts for the valuation of startups, based on new funding rounds. I want a time axis (X) that has evenly distributed time, even though the data points may not be evenly distributed. Example: let's say we follow company X for three years: 2012, 2013 and 2014. There are five funding events: Jan-13, June-13, Dec-13, Feb-14 and Oct-14. In a traditional Excel chart, there would be five datapoints, but this will be misleading. I want a chart where the X-distance is the same for all years, and you can see graphically when in time an event occurs. I could of course create a table with every date in the time series, and then create a value for each day, only incrementing it when a new round occurs. But this is very cumbersome, and there ought to be a better way.
This is built-in in Excel. Step by step (translated from German version, XL2003):
1. Select your x,y data
3. Choose "Line diagram" (as an example)
4. assistant starts, proceed to step 3
5. For "primary axis", choose "time axis"
You can even format the time axis later on to only show months, and adjust the starting and ending point in time.