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

 

Wow, I guess I should have read all the follow up post before I responded just a bit ago to what Dave was saying. I will definitely give this a look. Thanks.

--- In ExcelVBA@yahoogroups.com, <phil.ranson@...> wrote:
>
> 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@...
> 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 (8)

Recent Activity:

• New Members 5

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

.

__,_._,___