|
Graph Points
I have a graph with 40 points
I am trying to enter the apexs values (high & low) in cells next to the chart. Not having any luck with "=if(and(c3c4,c5,c4,c5,c4),if(and(etc. any suggestions or method appreciated I have max & min points ok |
Graph Points
Hi,
I think you just need the MIN and MAX formula. See this page. http://peltiertech.com/Excel/Charts/FormatMinMax.html Cheers Andy Duplatt wrote: I have a graph with 40 points I am trying to enter the apexs values (high & low) in cells next to the chart. Not having any luck with "=if(and(c3c4,c5,c4,c5,c4),if(and(etc. any suggestions or method appreciated I have max & min points ok |
Graph Points
Andy - Thank you. I can use your formula. However, what I am trying to
identify is the peak points other than MAX or MIN. If we start in 2002 with $60,000 and contribute $30,000 a year for 5 years we have $210,000, then we spend $100,000 (balance of $110,000) then contribute $180,000 over 6 years (new max of $290,000). I am trying to show the $210,000 and $110,000 points. Duane "Andy Pope" wrote: Hi, I think you just need the MIN and MAX formula. See this page. http://peltiertech.com/Excel/Charts/FormatMinMax.html Cheers Andy Duplatt wrote: I have a graph with 40 points I am trying to enter the apexs values (high & low) in cells next to the chart. Not having any luck with "=if(and(c3c4,c5,c4,c5,c4),if(and(etc. any suggestions or method appreciated I have max & min points ok |
Graph Points
Hi,
One way, assuming data in B2:B14, C2: =IF(AND(B2<B1,B1<0),B2,NA()) D2: =IF(AND(B2B3,B3<0),B2,NA()) Copy the cells down to C14:D14. Plot these as 2 series. Column C will give you the trough and D the peaks. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Duplatt" wrote in message ... Andy - Thank you. I can use your formula. However, what I am trying to identify is the peak points other than MAX or MIN. If we start in 2002 with $60,000 and contribute $30,000 a year for 5 years we have $210,000, then we spend $100,000 (balance of $110,000) then contribute $180,000 over 6 years (new max of $290,000). I am trying to show the $210,000 and $110,000 points. Duane "Andy Pope" wrote: Hi, I think you just need the MIN and MAX formula. See this page. http://peltiertech.com/Excel/Charts/FormatMinMax.html Cheers Andy Duplatt wrote: I have a graph with 40 points I am trying to enter the apexs values (high & low) in cells next to the chart. Not having any luck with "=if(and(c3c4,c5,c4,c5,c4),if(and(etc. any suggestions or method appreciated I have max & min points ok |
Graph Points
Andy - That is super, can't thank you enough.
Duane "Andy Pope" wrote: Hi, One way, assuming data in B2:B14, C2: =IF(AND(B2<B1,B1<0),B2,NA()) D2: =IF(AND(B2B3,B3<0),B2,NA()) Copy the cells down to C14:D14. Plot these as 2 series. Column C will give you the trough and D the peaks. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Duplatt" wrote in message ... Andy - Thank you. I can use your formula. However, what I am trying to identify is the peak points other than MAX or MIN. If we start in 2002 with $60,000 and contribute $30,000 a year for 5 years we have $210,000, then we spend $100,000 (balance of $110,000) then contribute $180,000 over 6 years (new max of $290,000). I am trying to show the $210,000 and $110,000 points. Duane "Andy Pope" wrote: Hi, I think you just need the MIN and MAX formula. See this page. http://peltiertech.com/Excel/Charts/FormatMinMax.html Cheers Andy Duplatt wrote: I have a graph with 40 points I am trying to enter the apexs values (high & low) in cells next to the chart. Not having any luck with "=if(and(c3c4,c5,c4,c5,c4),if(and(etc. any suggestions or method appreciated I have max & min points ok |
Graph Points
Your welcome.
-- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Duplatt" wrote in message ... Andy - That is super, can't thank you enough. Duane "Andy Pope" wrote: Hi, One way, assuming data in B2:B14, C2: =IF(AND(B2<B1,B1<0),B2,NA()) D2: =IF(AND(B2B3,B3<0),B2,NA()) Copy the cells down to C14:D14. Plot these as 2 series. Column C will give you the trough and D the peaks. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Duplatt" wrote in message ... Andy - Thank you. I can use your formula. However, what I am trying to identify is the peak points other than MAX or MIN. If we start in 2002 with $60,000 and contribute $30,000 a year for 5 years we have $210,000, then we spend $100,000 (balance of $110,000) then contribute $180,000 over 6 years (new max of $290,000). I am trying to show the $210,000 and $110,000 points. Duane "Andy Pope" wrote: Hi, I think you just need the MIN and MAX formula. See this page. http://peltiertech.com/Excel/Charts/FormatMinMax.html Cheers Andy Duplatt wrote: I have a graph with 40 points I am trying to enter the apexs values (high & low) in cells next to the chart. Not having any luck with "=if(and(c3c4,c5,c4,c5,c4),if(and(etc. any suggestions or method appreciated I have max & min points ok |
| All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com