Hi Hui,
Thank you so much. I find it very accurate with all the high and low point to the point. I would very much appreciated if you post on how to do this. I have more chart to do work with. :)
I need to extract data from line graphs in images, and I've been using an overlay method that requires manually adjusting each (x,y) point until it aligns with the corresponding point in the image. However, this is a time-consuming process, especially for larger datasets - my current graph has...
Hi,
Working with Max Function as described above.
This is the formula that got stuck with:
=MAX("G"&(D1-C1):"G"&(D1))
D1 = LARGE(E1:E100,1)
C1 = Number of row (Data, Not a formula)
Tried the array key press but result, #value.
Luke M,
Although I am not very confidence when I first receive your answer, I got it working on the first try. Been looking for the answer for quite sometimes. Am happy that someone had helped me. Again big thank you.
Hi,
This is a renew question.
I am working on graph auto update for X-axis. Macro A is for graph format and Macro B is for X-axis.
Macro A:
ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlValue).MaximumScale = [R2]
Macro B:
ActiveSheet.ChartObjects("Chart...
Luke M,
Is it possible to get the whole of <"='Sheet1'!" & [AQ30:AQ90].Address> to link to the spreadsheet like macro A?
If I need to change the range, I can instantly change from the spreadsheet instead of in the VBA.
Hi,
I get macro A to work but with same concept the macro B doesn't seem to work. What ever values added after = will be show in the graph series values. I have try function text and value but only show same result. Series value shows ='Sheet1'!$AD$22 instead of ='Sheet1'!$AQ$30:$AQ$90...
Full formula:
=IFERROR(INDEX('Sheet2'!$B$100:$B250,MATCH(C100/2,'Sheet2'!$C$100:$C$250,0)),"")
Can the formula be improved?
Details:
Formula is insert in Sheet 1 Column A. Sheet 2 is all data.
Sheet 1:
A B
1
30 2
3
30 4
5
30 6
7
30 8
9
30 10
11
30 12
Sheet 2:
A B
30 1
30 2...
Problem Solved.
After adjustment, new formula is
=index('Sheet1'!$D$100:$D$250,C100)
Thanks.
http://www.excelforum.com/excel-general/700964-how-to-fix-a-large-range-of-cells.html
Row 4.
Full formula:
=index('Sheet1'!D100:D250,C100)
The fix range is 'Sheet1'!D100:D250.
When copy and paste to other row, the range about is fix but C100 is flexible.
Searched online. The formula indirect is used but formula not working when linked to other sheet.
Other solution is welcome.
=Lookup(aaa,Column 1)
Column 1 consists of number 2, 4, 6, 8, 10, 12, 14, 16, 18, 20.
Full list of aaa is from 1 to 20.
The only formula error is:
=Lookup(1, Column 1)
=#N/A
How to get the formula to show result as 2? Result of 0 is not allowed.