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

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

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

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