Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 1st 05, 10:24 PM
Zadig Galbaras
 
Posts: n/a
Default Unwanted zero values in a graph

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  
Old June 1st 05, 10:54 PM
SVC
 
Posts: n/a
Default

From what you are saying, I wonder if the cells are really empty. Try
deleting the entire contents of the "blank" cells. If this does not work,
you can select each segment of the chart (you don't say what kind--line, bar,
etc.) and cause it to have no pattern, color, fill, etc. (Format Data Series).

"Zadig Galbaras" wrote:

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  
Old June 2nd 05, 04:05 AM
Ragdyer
 
Posts: n/a
Default

The #N/A error message is what you're looking for.
It works very well with graphs by not equating to zero.

So, revise your formulas to something like this:

=IF(OR(A1="",B1=""),# N/A,A1/B1)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"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
-




  #4   Report Post  
Old June 2nd 05, 04:44 AM
B. R.Ramachandran
 
Posts: n/a
Default

Hi,
I tried to mimic your problem by creating x-data containing 12 numbers (1
thru 12 in A1 thru A12) and y-data containing 6 numbers (in B1 thru B6) and
making XY-Scatter as well as Line plots by selecting A1:A12 and B1:B12. Both
graphs were fine, i.e., only the six data-points showed up, and the empty
values (B7 thru B12) DIDN'T show up as zeros on the graphs. I changed the
x-values to Jan 2005, Feb 2005, thru Dec 2005, and the line plot was still
fine. So I couldn't reproduce your problem. Are you sure your y-range cells
for future months were really blank (and didn't contain zeros)?
Or, you could use a self-expanding chart (For an excellent discussion, visit
'Stephen Bullen's Excel Page' at www.oaltd.co.uk/Excel/ and follow the link
'Professional Excel Development' ...'Advanced Charting Techniques'. It goes
as follows:

Name the x- and y- ranges first (Insert-Name-Define)
Names in workbook: Refers to:
yrange
=offset(Sheet1!$B$1,0,0,counta(Sheet1!$B:$B),1)
xrange =offset(yrange,0,-1)

Now create a dummy Line Chart (with a couple of x,y data), and get into
Source Data - Series, and enter =Sheet1!yrange for Values and =Sheet1!yrange
for Category (X) axis labels. The plot should contain only points for which
y-range contains values, and should update as you add more values.
Regards,
B.R.Ramachandran


"Zadig Galbaras" wrote:

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
graphs showing unwanted zero values Zadig Galbaras Excel Discussion (Misc queries) 2 June 1st 05 10:34 PM
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 10:02 PM
Graph values in ascending order Ant [email protected] Excel Discussion (Misc queries) 1 January 6th 05 06:10 PM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 01:27 PM


All times are GMT +1. The time now is 07:44 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017