Can I create Excel Graph with width proportional to the date period? -

Can I create Excel Graph with width proportional to the date period? -

for example, suppose a, b , c points:

table:

a                    01/01/2001                1

b                    01/01/2002                1

c                    01/01/2010                1

the spacing between , b must less b , c, , space proportional distance between dates.

this expected graph:

graphic:

  1                1                                                                          1

  o ---------- o --------------------------------------------------------- o  

2001         2002                                                                    2010

if create excel line chart, excel recognize x values dates , plot points want to. if doesn't, can format axis , create sure date type axis.

just select dates , values before making chart. if there column a, b, c in it, don't include in selection before making chart.

excel graph pivot-table