Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 23
Default Cutting a line in a line chart when data series stops

I have a series like so:

Jan 10
Feb 10
Mar 11
Apr 12
May
Jun
Jul

And so on - the rest of the year is blank. When I draw a line chart for the
full 12 months the series draws a line up to April, then plummets to zero in
May. I want the line to just stop at April. If I use a series as above and
genuine empty cells for the end of the year this ok, but since my May cell
reads =IF($A11<=$D$17,G11,"") the "" does not seem to get recognised as a
blank cell.

Please help!!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default Cutting a line in a line chart when data series stops

Change your formula to =IF($A11<=$D$17,G11,NA())
--
David Biddulph

"DannyS" wrote in message
...
I have a series like so:

Jan 10
Feb 10
Mar 11
Apr 12
May
Jun
Jul

And so on - the rest of the year is blank. When I draw a line chart for
the
full 12 months the series draws a line up to April, then plummets to zero
in
May. I want the line to just stop at April. If I use a series as above
and
genuine empty cells for the end of the year this ok, but since my May cell
reads =IF($A11<=$D$17,G11,"") the "" does not seem to get recognised as a
blank cell.

Please help!!



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 23
Default Cutting a line in a line chart when data series stops

Thanks David,

That works a treat for everything except area charts - I guess as they stack
they treat the N/As as 0's? Any idfeas for this case?

Much appreciated, Dan

"David Biddulph" wrote:

Change your formula to =IF($A11<=$D$17,G11,NA())
--
David Biddulph

"DannyS" wrote in message
...
I have a series like so:

Jan 10
Feb 10
Mar 11
Apr 12
May
Jun
Jul

And so on - the rest of the year is blank. When I draw a line chart for
the
full 12 months the series draws a line up to April, then plummets to zero
in
May. I want the line to just stop at April. If I use a series as above
and
genuine empty cells for the end of the year this ok, but since my May cell
reads =IF($A11<=$D$17,G11,"") the "" does not seem to get recognised as a
blank cell.

Please help!!




Reply
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
Why Color Flled Data Series on Line Chart Slants MP246AZ Charts and Charting in Excel 5 April 28th 07 08:01 PM
Line chart, multiple series, data is inter-mixed Bob[_5_] Charts and Charting in Excel 2 April 27th 07 07:13 PM
Combination chart: primary data labels obscure line series on secondary axis Uhl Charts and Charting in Excel 3 December 12th 06 09:52 PM
Why does Excel line chart cut off my data series? snowbound Charts and Charting in Excel 4 August 2nd 06 12:19 PM
Refreshing pivot makes second data series line disappear from chart !!! WhytheQ Excel Discussion (Misc queries) 4 July 4th 06 01:28 PM


All times are GMT +1. The time now is 07:28 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"