View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
TyreDude TyreDude is offline
external usenet poster
 
Posts: 3
Default Excel 2007 Line Chart - Chart line to go directly to next value

Hello,

Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
the periods:

Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0

I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.

I have no idea if this is possible, any ideas?

Thanks,
Brett