*The title should go the other way round - in 2010 moves range, in 2013 not. Thanks!
Hi All,
Thank you for the forum. I have got this issue.
1. A set o 10 rows of data - 10 to 1 (Z to A order)
2. Chart range spans over the 10 rows - 10 to 1
3. I add one row of data above those 10 - now I've got eleven - 11 to 1 (Picture 1: https://www.dropbox.com/s/v8ke6aapy0hh3y2/row.jpg?dl=0
4. Chart range spans over 10 rows, 1 is outstanding
5. I insert an empty row above and move rows down
6. In Excel 2010 chart range would move and keep spanning over the 10 to 1 rows, whereas in 2013 the chart range stays in place and now spans over rows 11 to 2. (Picture 2: https://www.dropbox.com/s/e3la7hih3kyd8yj/row 2.jpg?dl=0)
Anybody knows why?
This may be a silly question, but im my work we use both systems and one simple but crucial solution cannot be rolled out because of this.
Please help my dear Cellular friend!
Thank you!
Hi All,
Thank you for the forum. I have got this issue.
1. A set o 10 rows of data - 10 to 1 (Z to A order)
2. Chart range spans over the 10 rows - 10 to 1
3. I add one row of data above those 10 - now I've got eleven - 11 to 1 (Picture 1: https://www.dropbox.com/s/v8ke6aapy0hh3y2/row.jpg?dl=0
4. Chart range spans over 10 rows, 1 is outstanding
5. I insert an empty row above and move rows down
6. In Excel 2010 chart range would move and keep spanning over the 10 to 1 rows, whereas in 2013 the chart range stays in place and now spans over rows 11 to 2. (Picture 2: https://www.dropbox.com/s/e3la7hih3kyd8yj/row 2.jpg?dl=0)
Anybody knows why?
This may be a silly question, but im my work we use both systems and one simple but crucial solution cannot be rolled out because of this.
Please help my dear Cellular friend!
Thank you!
Last edited: