Re: overcoming zero values in line graph
From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 03/08/05
- Next message: Tushar Mehta: "Re: Linking Charts"
- Previous message: marika1981: "overcoming zero values in line graph"
- In reply to: marika1981: "overcoming zero values in line graph"
- Next in thread: John Harris: "Re: overcoming zero values in line graph"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 7 Mar 2005 22:43:21 -0500
There is no reason why you cannot have a 2nd data set that has the N/A
values. Plot this second set and use the first for whatever you are
using it for.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <FABDAB90-F576-4317-89B2-AB6F2BD37DC9@microsoft.com>, marika1981@discussions.microsoft.com says... > I have a 12-month line graph where some of the earliest and most recent data > is still zero. > > Is there a way to have Excel not plot zero values - to avoid the big rises > and drop offs they cause - and, rather, just have the graph start and end > wherever there is positive data? > > (NOTE: for multiple reasons, I can't erase the formulae in the cells > yielding the zero values, or have them display the N/A message....) > > Thanks!!! > > Marika :) > >
- Next message: Tushar Mehta: "Re: Linking Charts"
- Previous message: marika1981: "overcoming zero values in line graph"
- In reply to: marika1981: "overcoming zero values in line graph"
- Next in thread: John Harris: "Re: overcoming zero values in line graph"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
