Butterfly chart example

[mrybalko]

Hello.

Here is my butterfly chart solution. Max losses and profit values are highlighted. Values on data points are shown when less then 15 dates are selected (see vShownNum variable)

I used 2 bar charts and number format hints for losses bar.

[#2]

Hi Maxim,

Example is fine , plz can you explain how it was working ?

Regards,

Helen

[#3]

Hi Maxim,

This is great.

I am also trying to create Butterfly chart, but not able to do it.

Please see the attached Qvd and suggest what i am doing wrong.

Regards,

manish virmani

[Anil_Babu_Samineni]

Nice Explanation..

So, i have one small question.

If i have two tables with two date fields.

Is that possible to create Butterfly same as your qvw...

If possible, i will share my qvw so that i need big help from you

- Anil

[kmstephenson]

This is awesome!! How did you display Losses as a positive number on the chart data values and pop ups?

[mrybalko]

Pay attention to Format Pattern. It is used the same pattern for negative and positive numbers.

# ##0; # ##0

[kmstephenson]

Is it possible to do with a chart where I show percents? I used the following format:

But it doesn't work to use the same format for the left side of the chart because it shows the #s as negative, which I don't want:

[kmstephenson]

Ahhhh, just noticed all I needed was the semicolon and to repeat it! Thank you!!

[Anil_Babu_Samineni]

I am not sure, whether I understand your problem.

Perhaps this, (#,##0); (#,##0)