Select the cell and go to Edit>Clear>All. Now retype
the value. If that
doesn't work copy the values to another area and try adding
these as a
new series to your graph - gave a high value to one of the
cells so you
can differentiate between the two series. If this works, it
looks like
you may have a corrupt cell.
John Mulholland
-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-G PEACH.EASE.LSOFT.COM]
On Behalf Of Sally Lee
Sent: 30 August 2006 18:43
To: EXCEL-G PEACH.EASE.LSOFT.COM
Subject: Re: Graph value not recognized
*** WARNING ***
This mail has originated outside your organization, either
from an
external partner or the Global Internet.
Keep this in mind if you answer this message.
Thanks. The source data series for values goes through
column BC (which
is the June data), and the X axis labels go through column
BC.
************************************************************
********
This email and any attachments are confidential to the
intended
recipient and may also be privileged. If you are not the
intended
recipient please delete it from your system and notify the
sender.
You should not copy it or use it for any purpose nor
disclose or
distribute its contents to any other person.
************************************************************
********
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|