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: 79
Default I need a gap when the result of a formula is blank or zero

Hello everyone,

I have a line chart that plots the evolution of an economic indicator
over the months.

Each of the 12 cells plotted (the source range) has a formula. It
fetches a value from a dabase. For all the months to come, the formula
shows "" (like empty cell) or a blank (" "). I might use zero, were it
needed.

But what I need is that beyond the current month, the line makes a gap
(no dots) instead of treating formulas as zeroes.

Are there any parameters or options that could help me?

Thank you
Vicente Soler
 
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
formula result blank Leonard Excel Worksheet Functions 0 January 11th 07 08:45 AM
How to get Blank into a cell as a result of a formula jkb_junk Excel Worksheet Functions 2 January 10th 07 03:37 AM
Pasteing formula gives blank result garin Excel Worksheet Functions 0 August 3rd 06 01:11 PM
How to get a formula result zero as blank cell Excelerate-nl Excel Discussion (Misc queries) 4 November 22nd 05 04:32 PM
IF statement when formula result is blank Bonnie Excel Worksheet Functions 2 September 1st 05 05:08 PM


All times are GMT +1. The time now is 06:25 PM.

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

About Us

"It's about Microsoft Excel"