Correlation Chart

[SONJOE JOSEPH]

Dear Charting Experts,

I'm trying to figure out how to draw a correlation chart using the data attached in the excel file attached. Just want to look my chart attached in the "Sample Chart.png ". This chart should be dynamic ie when i update new data from 30 Jun-07 this has to get updated in the chart.

Do help me out to figure this out. Just tried several methods but was not able to do it successfully.

Regards,

Sonjoe Joseph.

 

[Chihiro]

Chart should be just simple line chart. With one of the series using secondary axis.

Once you chart simple line chart. Right click on one of the series and select "Change Series Chart Type". In the window, just check "Secondary Axis" box.

Edit: Sample image.

 

[Chihiro]

For the dynamic chart range, refer to Hui's post in below thread.
http://chandoo.org/forum/threads/automatically-updating-charts.32331/#post-191870

 

[SONJOE JOSEPH]

Chart should be just simple line chart. With one of the series using secondary axis.

Once you chart simple line chart. Right click on one of the series and select "Change Series Chart Type". In the window, just check "Secondary Axis" box.

Edit: Sample image.
View attachment 39892

Hello Chihiro,

Thank you for the reply but u havent attached ur working file. Anyway i will try to do it by myself. If things go wrong do help me out again.

Regards,

Sonjoe Joseph

 

[SONJOE JOSEPH]

For the dynamic chart range, refer to Hui's post in below thread.
http://chandoo.org/forum/threads/automatically-updating-charts.32331/#post-191870

Point noted and will work on. Any difficulties i will get back to you