Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 15th 05, 05:21 PM
Excel plot
 
Posts: n/a
Default ignore missing values while ploting graph

what commands do i need to give in order to ignore the missing values when i
am plotting the curve. By ignoring the missing values I will not get any
breaks in the plot

  #2   Report Post  
Old September 15th 05, 06:25 PM
Paul Sheppard
 
Posts: n/a
Default


Excel plot Wrote:
what commands do i need to give in order to ignore the missing values
when i
am plotting the curve. By ignoring the missing values I will not get
any
breaks in the plot


Hi Excel plot

Use #N/A, this will be ignored


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467925

  #3   Report Post  
Old September 15th 05, 06:48 PM
Mike
 
Posts: n/a
Default

Using the ctrl key, only highlight the cells with values and Insert - Chart.

"Excel plot" wrote:

what commands do i need to give in order to ignore the missing values when i
am plotting the curve. By ignoring the missing values I will not get any
breaks in the plot



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
Displaying values from zero on graph Marc Excel Discussion (Misc queries) 0 April 14th 05 09:21 PM
How to ignore zero values when plotting a graph Phil Lavis Charts and Charting in Excel 3 February 15th 05 11:02 PM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 01:10 PM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 02:27 PM
how can i get the slope function to ignore missing data? Delmar Excel Discussion (Misc queries) 0 December 2nd 04 06:55 PM


All times are GMT +1. The time now is 08:55 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017