| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I graph an equation instead of points? | New Users to Excel | |||
| Less points in graph | Excel Worksheet Functions | |||
| all points on a xy graph | Charts and Charting in Excel | |||
| label points on an XY graph | Charts and Charting in Excel | |||
| Graph with too many points - How to scroll? | Charts and Charting in Excel | |||
Linear Mode
