LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Stephan
 
Posts: n/a
Default How do I hide 0 values in line charts

I have several columns with data. In one column I do not have data for every
row. In the line charts, those "zero" values are plotted and connected with
the previous data point. Instead I would rather have a broken line. The
reason seems that I have a formula entered in this field instead on no entry
 
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
suppress zero values in line charts? Cruickshank Brothers Charts and Charting in Excel 4 June 12th 05 04:28 AM
How do I hide 0 values in line charts Stephan Charts and Charting in Excel 2 April 12th 05 12:55 PM
Hiding 0 values in line charts Teri Charts and Charting in Excel 4 February 22nd 05 12:40 PM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 12:10 PM
suppress zero values in line charts? cruickshankbrothers Charts and Charting in Excel 0 January 14th 05 10:27 PM


All times are GMT +1. The time now is 07:40 AM.

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"