[ExcelVBA] Re: Copy column range of formulas to next column

 

Steve,

I also had the problem of chart data using formulae which evaluated to
zero in future periods with no data - and thus making the chart look
ridiculous with my chart lines all gravitating to the X axis (zero). The
solution I came across was to use an if condition in the formulae and
get each item of chart data to evaluate to the NA() formula when there
was no actual data. In contrast to zeros this NA() formula is completely
ignored by the chart - so the chart looks sensible (blank) in future
periods. I have not tried this with a trend line but I would expect it
to work.

Best Regards
Phil.

Control Techniques
Emerson Industrial Automation
Ty Rheoli, 79 Mochdre Industrial Estate
Newtown, , United Kingdom SY16 4LE
Tel: +44 (0)1686 612600
Fax:
Email: Phil.Ranson@emerson.com
Web: www.controltechniques.com <http://www.controltechniques.com/>


Control Techniques Drives Limited. Registered Office: The Gro, Newtown, Powys SY16 3BE. Registered in England and Wales. Company Reg. No. 01384703

This electronic mail message contains information which is intended only for the use of the Addressee(s) named herein and which may be confidential. If you are not the Addressee(s), or the person responsible for delivering this to the Addressee(s), you are hereby notified that reading, copying, or distributing this message is prohibited. If you have received this electronic mail message in error, please contact us immediately at the telephone number shown below and take the steps necessary to delete the message completely from your computer. Thank you. Control Techniques Drives Ltd at +44 (0)1686 612300

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 9

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___