| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you skip graphing some data?
Hi all,
Is there a way to make missing data not be charted in an excel graph? What I mean is... if my data set is as follows: Jan 3 Feb 0 Mar 2 Apr 5 May No data Jun No data Jul 2 etc How do I make it graph Jan to Apr and Jul but make the May and June points not appear on the chart at all. I used to be able to do this by putting #N/A for May and June but now it actually graphs the points as #N/A rather than completely ommitting them (which is what I want). Any help would be much appreciated. Thanks guys. Kim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you skip graphing some data?
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you skip graphing some data?
Thanks Don. Is there another way? I like using #n/A because I can
control it with formlas. Don Guillett wrote: hide em -- Don Guillett SalesAid Software "Kim" wrote in message ups.com... Hi all, Is there a way to make missing data not be charted in an excel graph? What I mean is... if my data set is as follows: Jan 3 Feb 0 Mar 2 Apr 5 May No data Jun No data Jul 2 etc How do I make it graph Jan to Apr and Jul but make the May and June points not appear on the chart at all. I used to be able to do this by putting #N/A for May and June but now it actually graphs the points as #N/A rather than completely ommitting them (which is what I want). Any help would be much appreciated. Thanks guys. Kim |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you skip graphing some data?
Not sure? Do you have any idea because that system really did the
trick. Thanks again RagDyer wrote: Why doesn't the #N/A work anymore? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Don Guillett" wrote in message ... hide em -- Don Guillett SalesAid Software "Kim" wrote in message ups.com... Hi all, Is there a way to make missing data not be charted in an excel graph? What I mean is... if my data set is as follows: Jan 3 Feb 0 Mar 2 Apr 5 May No data Jun No data Jul 2 etc How do I make it graph Jan to Apr and Jul but make the May and June points not appear on the chart at all. I used to be able to do this by putting #N/A for May and June but now it actually graphs the points as #N/A rather than completely ommitting them (which is what I want). Any help would be much appreciated. Thanks guys. Kim |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you skip graphing some data?
This is how NA() or #N/A works in "marker charts" (XY charts, line charts,
and unfilled radar charts) Excel 97-2007. If you think it used to work differently, you may be thinking of its behavior with a different combination of lines and markers. * If the series has markers only and no points, NA() results in a missing marker corresponding to the missing value. * If the series has lines, NA() results in a line from the point preceding the missing value(s) to the point following the missing value(s). * If the NA() occurs at either end of the data range, there is no line spanning the gap, because there is a point on only one side of the gap. * The point corresponding to NA() is not even present, so it has no data label. In other types of charts, NA() or #N/A is treated as a zero value, the point is plotted at zero, and if you have data labels displaying the value of the point, this point's data label will display "#N/A". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kim" wrote in message ups.com... Hi all, Is there a way to make missing data not be charted in an excel graph? What I mean is... if my data set is as follows: Jan 3 Feb 0 Mar 2 Apr 5 May No data Jun No data Jul 2 etc How do I make it graph Jan to Apr and Jul but make the May and June points not appear on the chart at all. I used to be able to do this by putting #N/A for May and June but now it actually graphs the points as #N/A rather than completely ommitting them (which is what I want). Any help would be much appreciated. Thanks guys. Kim |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you skip graphing some data?
Thanks for the info Jon.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jon Peltier" wrote in message ... This is how NA() or #N/A works in "marker charts" (XY charts, line charts, and unfilled radar charts) Excel 97-2007. If you think it used to work differently, you may be thinking of its behavior with a different combination of lines and markers. * If the series has markers only and no points, NA() results in a missing marker corresponding to the missing value. * If the series has lines, NA() results in a line from the point preceding the missing value(s) to the point following the missing value(s). * If the NA() occurs at either end of the data range, there is no line spanning the gap, because there is a point on only one side of the gap. * The point corresponding to NA() is not even present, so it has no data label. In other types of charts, NA() or #N/A is treated as a zero value, the point is plotted at zero, and if you have data labels displaying the value of the point, this point's data label will display "#N/A". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kim" wrote in message ups.com... Hi all, Is there a way to make missing data not be charted in an excel graph? What I mean is... if my data set is as follows: Jan 3 Feb 0 Mar 2 Apr 5 May No data Jun No data Jul 2 etc How do I make it graph Jan to Apr and Jul but make the May and June points not appear on the chart at all. I used to be able to do this by putting #N/A for May and June but now it actually graphs the points as #N/A rather than completely ommitting them (which is what I want). Any help would be much appreciated. Thanks guys. Kim |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you skip graphing some data?
I'm thinking I should write a page around it, as a more permanent location
for this important concept. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "RagDyer" wrote in message ... Thanks for the info Jon. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jon Peltier" wrote in message ... This is how NA() or #N/A works in "marker charts" (XY charts, line charts, and unfilled radar charts) Excel 97-2007. If you think it used to work differently, you may be thinking of its behavior with a different combination of lines and markers. * If the series has markers only and no points, NA() results in a missing marker corresponding to the missing value. * If the series has lines, NA() results in a line from the point preceding the missing value(s) to the point following the missing value(s). * If the NA() occurs at either end of the data range, there is no line spanning the gap, because there is a point on only one side of the gap. * The point corresponding to NA() is not even present, so it has no data label. In other types of charts, NA() or #N/A is treated as a zero value, the point is plotted at zero, and if you have data labels displaying the value of the point, this point's data label will display "#N/A". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kim" wrote in message ups.com... Hi all, Is there a way to make missing data not be charted in an excel graph? What I mean is... if my data set is as follows: Jan 3 Feb 0 Mar 2 Apr 5 May No data Jun No data Jul 2 etc How do I make it graph Jan to Apr and Jul but make the May and June points not appear on the chart at all. I used to be able to do this by putting #N/A for May and June but now it actually graphs the points as #N/A rather than completely ommitting them (which is what I want). Any help would be much appreciated. Thanks guys. Kim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| graphing data of different frequencies | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Linear Mode
