Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Zadig Galbaras
 
Posts: n/a
Default graphs showing unwanted zero values

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
-



  #2   Report Post  
Daniel CHEN
 
Posts: n/a
Default

Select Chart, goto menu:

Tools/Options/Charts - make "plot empty cell as not plotted" checked.

"Zadig Galbaras" wrote in message
...
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
-





  #3   Report Post  
Zadig Galbaras
 
Posts: n/a
Default

Hi Daniel

Done that, but it doesn't seem to work

--

regards
Zadig Galbaras
A Perturbed Norwegian Agnostic
-


"Daniel CHEN" skrev i melding
...
Select Chart, goto menu:

Tools/Options/Charts - make "plot empty cell as not plotted" checked.

"Zadig Galbaras" wrote in message
...
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
-







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
Zero values in a log chart Joelle_Smith Charts and Charting in Excel 2 May 8th 23 03:42 AM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
Line graphs with null values Darren Hagarty Charts and Charting in Excel 3 January 12th 05 09:02 AM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 05:15 AM
Spreadsheet is only showing formulas not the actual values John Excel Worksheet Functions 2 November 24th 04 07:13 PM


All times are GMT +1. The time now is 08:39 AM.

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

About Us

"It's about Microsoft Excel"