plot - How to make a step-chart in Microsoft Access? -

currently, have table dates of price changes in various goods. have form line chart like:

instead, more accurate me have step-chart like:

but can't find how change chart type step-chart in access 2007. ideas?

one way "fake" such chart create query repeats previous price before next one. example, sample data

date        price ----------  ----- 2013-08-01  $6.00 2013-08-02  $5.00 2013-08-03  $5.00 2013-08-04  $6.00 2013-08-05  $8.00 2013-08-06  $9.00 2013-08-07  $7.00 2013-08-08  $6.00 2013-08-09  $7.00 

you use query

select [date], [price] prices union select dateadd("s",86399,[date]), [price] prices order 1; 

to produce data

date                price ------------------- ----- 2013-08-01          $6.00 2013-08-01 23:59:59 $6.00 2013-08-02          $5.00 2013-08-02 23:59:59 $5.00 2013-08-03          $5.00 2013-08-03 23:59:59 $5.00 2013-08-04          $6.00 2013-08-04 23:59:59 $6.00 2013-08-05          $8.00 2013-08-05 23:59:59 $8.00 2013-08-06          $9.00 2013-08-06 23:59:59 $9.00 2013-08-07          $7.00 2013-08-07 23:59:59 $7.00 2013-08-08          $6.00 2013-08-08 23:59:59 $6.00 2013-08-09          $7.00 2013-08-09 23:59:59 $7.00 

and if display data x-y chart this: