If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Problem with dynamic chart

Thread starter konradz
Start date Aug 31, 2012
Tags

dynamic chart error offset charts offset formula

konradz

New Member

Aug 31, 2012

I developed dynamic chart with use of the offset formula. The data range in a chart is expressed like that:

Code:

='time series profiler.xlsx'!income_y

After saving and closing file the formula alters itself and looks like that:

Code:

=[COLOR=#ff0000][B][0][/B][/COLOR]!income_y

Obviously, at this stage the chart loses the dynamic functionality and it is necessary to alter the data range manually. I'm utterly perplexed to why it happens.

Last edited: Aug 31, 2012