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
|
|||
|
|||
Fill Positive and Negative Areas under a Scatter Plot Different Co
I have a scatter plot connected by lines. I want to be able to fill the
positive area between the line and 0 green and the negative area between the line and 0 red. Any ideas on how this would be possible? I looked at Jon Peltier's website but that only allows for one type of shading. Thanks Adam Bush |
#2
|
|||
|
|||
Fill Positive and Negative Areas under a Scatter Plot Different Co
Hi,
I think you[re going to have problems with this one. I don't think you can do this on a scatter chart in Excel. You can fake it with an area chart but there are a number of problems with that approach, not the least of which is it is not an XY scatter. -- If this helps, please click the Yes button. Cheers, Shane Devenshire " wrote: I have a scatter plot connected by lines. I want to be able to fill the positive area between the line and 0 green and the negative area between the line and 0 red. Any ideas on how this would be possible? I looked at Jon Peltier's website but that only allows for one type of shading. Thanks Adam Bush |
#3
|
|||
|
|||
Fill Positive and Negative Areas under a Scatter Plot Different Co
adambush4242
You can get close to what you want by creating 2 series and using colored error bars. I have an Excel example at this link. http://processtrends.com/pg_global_w...erature_Trends If this example meets your needs, you can download the workbook to see how I generated the double colored XY chart with error bars. Look at the CRU sheet. The chart you really want to make is very straightforward if you add R to your charting toolkit. Here's a link to a post I have on a panel chart with colored lines reflecting above - below zero status. .. http://chartsgraphs.wordpress.com/20...s-excel-chart/ If you plan to make advanced charts, you may want to add learn R so that you make advanced charts in R and paste the results into your Excel workbook. Kelly "Shane Devenshire" wrote in message news Hi, I think you[re going to have problems with this one. I don't think you can do this on a scatter chart in Excel. You can fake it with an area chart but there are a number of problems with that approach, not the least of which is it is not an XY scatter. -- If this helps, please click the Yes button. Cheers, Shane Devenshire " wrote: I have a scatter plot connected by lines. I want to be able to fill the positive area between the line and 0 green and the negative area between the line and 0 red. Any ideas on how this would be possible? I looked at Jon Peltier's website but that only allows for one type of shading. Thanks Adam Bush |
#4
|
|||
|
|||
Fill Positive and Negative Areas under a Scatter Plot Differen
Kelly,
Thanks for your response. The error bars are a nice idea, however some of my points are too spaced out for that to be effective. I appreciate your help though and if you have any more ideas I'd love to hear them. Thanks Adam Bush "Kelly O'Day" wrote: adambush4242 You can get close to what you want by creating 2 series and using colored error bars. I have an Excel example at this link. http://processtrends.com/pg_global_w...erature_Trends If this example meets your needs, you can download the workbook to see how I generated the double colored XY chart with error bars. Look at the CRU sheet. The chart you really want to make is very straightforward if you add R to your charting toolkit. Here's a link to a post I have on a panel chart with colored lines reflecting above - below zero status. .. http://chartsgraphs.wordpress.com/20...s-excel-chart/ If you plan to make advanced charts, you may want to add learn R so that you make advanced charts in R and paste the results into your Excel workbook. Kelly "Shane Devenshire" wrote in message news Hi, I think you[re going to have problems with this one. I don't think you can do this on a scatter chart in Excel. You can fake it with an area chart but there are a number of problems with that approach, not the least of which is it is not an XY scatter. -- If this helps, please click the Yes button. Cheers, Shane Devenshire " wrote: I have a scatter plot connected by lines. I want to be able to fill the positive area between the line and 0 green and the negative area between the line and 0 red. Any ideas on how this would be possible? I looked at Jon Peltier's website but that only allows for one type of shading. Thanks Adam Bush |
Thread Tools | |
Display Modes | |
|
|