LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Diagram that selects reference area automatically?

I have a to make a x,y-plot, where there in the reference area is not at
corresponding y-value after certain x value €“ the x value where the
calculation stops is variable and depending on other things. Because there in
the y-cells is a formula that is said to give "", when the calculations is
not to be made, the plot looks really funny.
Is it possible to do so that the reference area is automatically selected
where y0 or so that it will not plot x,y-values, where the y-value is a
formula that result that results in "" ? Or should it be another sign than ""
I should use?
Maybe macros can help me?

 
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
How can I automatically add an area code to a number in a cell? Disaster Lady Excel Worksheet Functions 8 February 26th 08 10:39 PM
when I select a cell, it automatically selects 2 or more below Ricochet Excel Discussion (Misc queries) 1 November 6th 07 08:49 PM
What is a reference area in Microsoft Excel rw7402 Excel Discussion (Misc queries) 1 October 31st 06 08:21 AM
how do i update a chart area automatically Kay Charts and Charting in Excel 4 February 10th 06 08:10 PM
mouse selects area Todd Excel Worksheet Functions 3 January 21st 05 09:20 PM


All times are GMT +1. The time now is 06:51 AM.

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

About Us

"It's about Microsoft Excel"