I am attempting to build a pseudo timeline with a range of -300000 to +2050 with individual events indicated on the horizontal time line at the appropriate place. The increments of the horizontal line are not equal and are based on values in column A of the spreadsheet and the event pseudo dates values are in column B. I would like it to look something like this:
I_____I__I___I________I_________I_I_I_____I____I
Is this possible using the charting wizard?
I would like to update it frequently adding additional items in column B.
I have played with this for a couple of days and haven’t figured out how to achieve the desired result or something even close. The values in the cells in column B are displayed on the Y-axis.
If this is not feasible, just let me know.
Thanks in advance,