Re: graphs showing unwanted zero values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Daniel

Done that, but it doesn't seem to work

--

regards
Zadig Galbaras
A Perturbed Norwegian Agnostic
-


"Daniel CHEN" <UDQServices@xxxxxxxxx> skrev i melding
news:e7S4$CvZFHA.2212@xxxxxxxxxxxxxxxxxxxxxxx
> Select Chart, goto menu:
>
> Tools/Options/Charts - make "plot empty cell as not plotted" checked.
>
> "Zadig Galbaras" <zadig@xxxxx> wrote in message
> news:d7l8ef$scn$1@xxxxxxxxxxxxxxxxx
>> Hi!
>>
>> Here I am once again.
>>
>> I have some graphs in a spreadsheet, and the sourcedata is being filled
>> with values as time goes on and I key in new values every fisrt day of
>> the month.
>> Hence the cells containing future readings is empty.
>>
>> The graph jumps from the latest value lets say 40, and stoops down to
>> zero on the X-axis, and follows it the for the rest of the year.
>>
>> How can I get my graphs to stop showing any line after the latest typed
>> value?
>> I have tried every possible combination when cliking the graph, choose
>> Options on the Tools menu, and the tab named Graph, but in vain. Nothing
>> happens.
>>
>>
>> --
>>
>> regards
>> Zadig Galbaras
>> A Perturbed Norwegian Agnostic
>> -
>>
>>
>>
>
>


.

Relevant Pages

  • Re: Is this an NP complete problem?
    ... Best regards, ... A graph G is a pair, where V is a set of vertexes, ... > We must all be aware that new maths is being created far faster than any one ... In one cut set, the lines are either red or yellow. ...
    (comp.theory)
  • Re: Getting values from the plots
    ... have a look at the rangefrompoint method, ... Regards, ... > I need to create a graph control that allows me to plot the graph from an ... > mouse up and mouse down to get the cursor positions on the graph. ...
    (microsoft.public.office.developer.web.components)
  • Re: Render url stream
    ... I cannot check any graph ... > event) on the calling thread until it got the first frame. ... > Best regards, ...
    (microsoft.public.win32.programmer.directx.video)
  • Re: Failed 292 as well
    ... not a score graph where can did you get your score ... Best Regards, ... > Also, compared to the MCSE 2000 tests I've taken, I really ... > felt like some questions were aksing me to make ...
    (microsoft.public.cert.exam.mcsa)
  • Re: Symbol file missing...
    ... Regards ... >> smart card reader and a Creative Web camera. ... >> Right now the Sound card and one of the two 80GB hard disks is removed. ... >> Zadig Galbaras ...
    (microsoft.public.windowsxp.configuration_manage)