Line chart

I am sorry for my yesterday bad explanation of the matter. I drew a line
chart starting from a table that contains the security values, for
instance the NASDAQ index, ranging from 1985 to date. Then I display
the chart for a specific date range.
At this point I draw manually, on the line chart, a trend line to
indicate the trend: imagine a line between two arbitrary points on the
chart depending on the evolution of the security.
My goal is to obtain, by some VBA procedure, the coordinates of the end
points (in the units of the chart, date and $) of the line I drew
before in order to set the relative position of the line and the chart
when I select other data range.
I hope to tried to explain a little bit better my question.
Regards
Giuseppe


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

See the response in the original discussion.

--
[Posted directly to the Usenet newsgroup -- no affiliation with
Excelforum]

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I am sorry for my yesterday bad explanation of the matter. I drew a line
chart starting from a table that contains the security values, for
instance the NASDAQ index, ranging from 1985 to date. Then I display
the chart for a specific date range.
At this point I draw manually, on the line chart, a trend line to
indicate the trend: imagine a line between two arbitrary points on the
chart depending on the evolution of the security.
My goal is to obtain, by some VBA procedure, the coordinates of the end
points (in the units of the chart, date and $) of the line I drew
before in order to set the relative position of the line and the chart
when I select other data range.
I hope to tried to explain a little bit better my question.
Regards
Giuseppe


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Hi
try changing your formula with the division to something like
=IF(B1=0,NA(),A1/B1)
to return #NA in case of a division by zero. This cell shouldn't be
charted

--
Regards
Frank Kabel
Frankfurt, Germany

"Nan " schrieb im Newsbeitrag
...
I'm setting up a line chart that is updated daily. I would like to
set
it up a month in advance so that the user only has to type in the new
data and the chart updates automatically. The chart data is linked to
cells on different worksheets. The cells that the chart is linked to
contain formulas (AVERAGE). Is there a way to prevent the line from
dropping to the X axis when there is no data yet?

For example, data for April 8 has yet to be entered. The cell for
April
8 data (which contains the AVERAGE formula) has #DIV/0! in it because
no data has yet to be entered. This makes my chart drop to the X axis
for April 8.

Any help is greatly appreciated!


---
Message posted from http://www.ExcelForum.com/

Hi
what is in the range H4:H32. If there's at leat one entry AVERAGE
should not return an error. Or are there error values in the range
H4:H32

--
Regards
Frank Kabel
Frankfurt, Germany

"Nan " schrieb im Newsbeitrag
...
I'm still having problems. I modified your formula (and maybe that's
the
problem) to be IF(H4=0,NA(),AVERAGE(H4:H32). I want the average of
the
H column, regardless of how many entries there may be (there may be
only 5 on a given day). I still get the division error.

I tried this formula as well....IF(H4="","",AVERAGE(H4:H32). This
leaves the cell blank (which is good). However, it messes up my
chart.

Part of my problem may also be that, because I have so many sheets, I
created a separate sheet with the chart data (linked to all the other
sheets). Therefore, I need a formula in the chart data sheet that my
chart thinks is blank and won't graph.

I hope that makes sense.


---
Message posted from http://www.ExcelForum.com/

Hi
try
IF(COUNTA(H4:H32)0,AVERAGE(H4:H32),NA())

--
Regards
Frank Kabel
Frankfurt, Germany

"Nan " schrieb im Newsbeitrag
...
There's nothing in the H4:H32 range. I'm trying to set it up for the
user for a future date so they don't have to do it.


---
Message posted from http://www.ExcelForum.com/