To Track New Add In Data on Graph (with contant months required)

[allenpee85]

Dear Guys,

I have a excel graph and would like it to:-

a) graph will change according to new data added
b) with condition only read the last 6 months data while there is incoming data

Please refer to the uploaded file.

Thank you.

 

[Nebu]

Hi:

Go through the following.

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/

Thanks

 

[allenpee85]

Hi:

Go through the following.

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/

Thanks

Dear Nebu,

Thanks for the infor.

However, I couldnt understand some of the points.

Is it possible to provide the sample calculation as from provided file?

Much appreciated.

 

[Nebu]

Hi:

Find the attached, enter the last number of the last months you want to display in the chart in Cell B2. I have created named ranges to achieve this.

Thanks

 

[allenpee85]

Hi:

Find the attached, enter the last number of the last months you want to display in the chart in Cell B2. I have created named ranges to achieve this.

Thanks

Thanks Nebu.
You are excellent!!!

 

[allenpee85]

Thanks Nebu.
You are excellent!!!

Dear Nebu,

I have encountered another issue.

The graph displayed couldn't show the "Month".

Please Help.....

P/S: I have uploaded a file for investigation.

 

[Nebu]

Hi:

I have fixed it , I have added one more named range called months.

Thanks

 

[allenpee85]

Hi:

I have fixed it , I have added one more named range called months.

Thanks

Thank you Nebu for the brilliant idea!