LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Goal line or target line to Excell 2007 Chart hawaiiham2000 Charts and Charting in Excel 5 October 2nd 09 05:35 PM
change line formatting in line chart - Excel 2007 LisaK Charts and Charting in Excel 1 August 27th 09 11:09 AM
How do I convert a line chart to a vertical line chart in Excel Gerty Charts and Charting in Excel 1 August 20th 09 04:28 PM
Line Chart Excel 2007 Shadowman13 Charts and Charting in Excel 1 May 14th 09 03:58 PM
Bar Chart to line chart excel 2007 RPG Charts and Charting in Excel 2 August 1st 08 07:32 PM


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"