If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
Line Chart
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/ |
#4
|
|||
|
|||
Line Chart
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/ |
#5
|
|||
|
|||
Line Chart
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/ |
Thread Tools | |
Display Modes | |
|
|