Horizontal Bar Chart - Dynamic?

**teylyn** · 09-15-2009, 06:21 PM

Hi

I hope the above makes sense.

Not much, I'm afraid. To me, anyway.

I would love to create a horizontal bar chart that plots all occurances of "WIN" "LOSS" & their frequency.

How do you determine the frequency? you have 500 cells, some have WIN, some have LOSS.

So,, the chart would show all 2 colour bars, Blue for "WIN", red for "LOSS"
So in order the chart would 1st show all 1 occurrence, then 2, then 3, then 4 occurrences etc etc

"1 occurrence"??? What do you mean?

So for example, if there were "WIN" occurred 4 times in a row out of the 500 trade sample & "LOSS" occurred 6 times, the horizontal bar for "WIN" would be blue and be 4, the horizontal "LOSS" red bar would come out to 6

I don't get it.

In any case, Excel won't be able to produce a chart from this data. You will need to create a table where you prepare the data for plotting. Excel charts do not summarize, total, or calculate, they can just plot numbers in cells.

Please try to explain what exactly you want the chart to show, and please keep in mind that we don't know your project as well as you do, so may require explanations for things that seem obvious to you.

Oh, and you may want to indicate in your profile that you're using 2007....

cheers

**theghost** · 09-16-2009, 02:53 AM

Many many thanks for your reply Teylyn.
I have just got in from work, (6.15am), just read your reply...

Sorry for confusion

I have amended my profile also to show excel 2007 as you suggested.

I have created an example in excel that I have screen captured (wasn't a chart) as I don't know how to do it, so I have created the same (kind of) as an example.
I attach the .jpeg

Basically Teylyn, it shows the random 500 trades and how many times Wins or Losses occurred.
So, for example, down the left hand side (Not sure if this is x or y axis

), there are the numbers 1 to 14.
This means that out of the 500 trades simulated, you can see that if a "WIN" occurred on it's own (so a loss would precede a win or follow a win), this happened 42 times out of 500 (Or 8.4%)
If you look at the number 7,,,, you can see the "WINS" that occurred 7 times in a row before a loss happened. 7 WINS in a Row occurred 18 times (Or 3.6% out of 500 trades)
And "LOSSES" that occurred 7 times in a row before a win happened 12 times (OR 2.4% of the time)

I hope all the above makes sense....................
That said,,,, It is now 7.42 AM,, been on long night shift and I can see that I have made a big mistake with the calculations

I hope the jpeg gives you the right idea,, but I can see that I am way off on my figures,,, as for example,,,
using the 7 wins or losses in a row,,, I have them showing as occurring 18 times and 12 times,,,, but 18 & 12 would need to be multiplied by 7,,IE (126 Wins have been used up out of the 500 & 84 losses have been used,, so 210 trades have been used out of the 500........

I would need to do another screen capture with all amended figures so it all works out correctly,,, but my eyes are starting to close

(God I hate night shifts ...:-)

I hope the screen capture helps and explains it all better Teylyn.
Hopefully you get a better idea of what I'm trying to achieve.
I hope you can help Teylyn.
Many thanks again for your reply.

TheGhost