Associated Curve chart

[#1]

Hi,

I wanted to use the below associated curve chart to show cross-selling between products and was able to successfully retrive the backend data and do minor changes

(http://qvdesign.wordpress.com/2012/09/21/informative-curvy-never-before-seen-by-me-at-least-the-asso...)

I have made some changes. However in order to fully replicate this.i need to know what does the following columds do

1- Position (How this is calculated in excel file)

2- X (How this is calculated in excel file)

3- Y (How this is calculated in excel file)

[sujeetsingh]

Yousuf..

This axes is just for the presentation of the dimension and Calculation in the chart.

You can get the other part of the visual chart only if you are having the '-ve' results .

All other things you have copied it to the point Good!!

[#3]

Hi,

Thanks for looking into this.

has he hardcoded the axis? My data set is quite huge. So i am not sure how to set the axis for each month.

also, what does the position specify? again how to set the position dynamicallly for each month for the entire data set.