Anu Singhee
New Member
hi,
Befor i write my query I want to thank you for this amazing web site.Everything which i now about excel chrts are becuse of you.
I work in investment banking i have 14 clients,i maintain a trends file with data for the last 3 years.My investor name are in columns and dates are in rows.I update the data every month.But i need the chart for the last 12 months.Every time i have to change my data range .could you please to make this dynamic.
Befor i write my query I want to thank you for this amazing web site.Everything which i now about excel chrts are becuse of you.
I work in investment banking i have 14 clients,i maintain a trends file with data for the last 3 years.My investor name are in columns and dates are in rows.I update the data every month.But i need the chart for the last 12 months.Every time i have to change my data range .could you please to make this dynamic.