different colors in a normal distribution

**Pasha81** · 10-29-2009, 07:55 AM

I have a histogram of normally distributed returns, so the left half of the histogram is negative and the right have positive. How do I give it different colors?

I tried to use 2 different series but that didnt work, as it dumped all the data in the left half of the chart.

please advise

thanks

**Andy Pope** · 10-29-2009, 08:27 AM

Can you post example workbook, including the 2 series attempt you made.

**Pasha81** · 10-29-2009, 10:12 AM

hey Andy

if you see in Column C, i've highlighted the values in red and blue-- thats the colour i need in the graph, negative in red, positive in blue

any thoughts?
thanks

**Andy Pope** · 10-29-2009, 10:30 AM

Plot the 2nd series on the same axis as the same chart type.
Just reduce the number of rows used as the Values .

**Pasha81** · 10-29-2009, 10:41 AM

Hi Andy,

I was actually trying to color the histogram(the different bars on it), not the normal curve....
how should i make the adjustment

thanks

**Andy Pope** · 10-29-2009, 10:49 AM

Sorry my mistake.

I have added an extra column just to make it clearer.

Once you have the 2 series of columns you need to set Overlap =100 and gapwidth =0

**Pasha81** · 10-29-2009, 11:03 AM

Thanks a lot Andy! that works
by the way, just wondering do Y error bars add value to a chart like this?
I'm showing daily returns here.

**Andy Pope** · 10-29-2009, 11:11 AM

What would the error bars be attempting to show?

**Pasha81** · 10-29-2009, 11:41 AM

Well i'm not sure if it has any use. My chart is basically showing the frequency distribution of daily returns made on say a stock portfolio....i was just wondring what this Y-error bar function is used for, can it be used to show say deviation from a mean?
could it add value in the kind of graph i have here?

I'll mark the thread as solved

Thanks for the help Andy!

**Andy Pope** · 10-29-2009, 11:44 AM

If you calculated the deviation from a mean in a range you could then use the custom value for the error bars.

I don't know stats well enough to tell you whether any displayed value would help.

**Pasha81** · 10-29-2009, 11:49 AM

thats fine, no worries. Thanks again

**Pasha81** · 10-29-2009, 11:55 AM

Oh and just a question why was is necessary to set Overlap = 100 and Gap = 0, the chart is still working the wayi wanted

different colors in a normal distribution

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Re: different colors in a normal distribution

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions