How do i get U shape Chart ?

[jd16]

Hello All, how do I get U shape chart with same data ? chart and snapshot(what I want exactly in my sheet) attached with this post.

Thanks in Advance
Regards

[Andy Pope]

The image is ranked on the X axis by dollar amount. It just so happens the chart makes a U.

Your data is just values with no meaning. I'm sure this is more complex than the details you have provided.

Anyway you need to arrange your data so the outer items have the largest value, getting smaller as you reach the center.

[BadlySpelledBuoy]

The shape of the graph is dictated by the data you are plotting.
Your example graph does not show a "U-shape" because the figures do not lend themselves to that.

[jd16]

Thanks for prompt reply Andy pope & BadlySpelledBuoy
Actually there is a website who always provide the same chart(in U shape) with your random data, though you give any value in your column/row ie. as I have provided in my worksheet, I have a complex datasheet hence I didn't attached that because perhaps one can get confused with data, so I just given an example and wants to get an idea about how they do it with any data, they always give you an U shape chart.
hope this will clear some air.

Regards

[Andy Pope]

Then you can add 2 helper columns and sort your data.

Assuming your data is in A1:B15, this includes category labels in column A

C2: =MOD(ROW(),2)
D2: =IF(C2=0,-1,1)*B2

sort A1:D15 on column C and column D, smallest to largest.

[jd16]

Then you can add 2 helper columns and sort your data.

Assuming your data is in A1:B15, this includes category labels in column A

C2: =MOD(ROW(),2)
D2: =IF(C2=0,-1,1)*B2

sort A1:D15 on column C and column D, smallest to largest.

Once again thanks AndyPope, sorry i'm a novice to excel so not getting you, can you please show me with this data copied from my original sheet, how can I do that and how it will be appear..

Thanks in advance
Regards

[Andy Pope]

example attached