One rather annoying feature of charts is that they crop the range of charted cells to the area containing data. This means as you insert new rows you have to edit each chart to add new rows.
When you have a range that is dis-contiguous, you have to edit several times in a long string to expand the range.
It would be rather lovely if there was some "add row" and "add column" button / icon that would extend each of these selected areas:
Double click on a chart (of some data in a sheet - from a couple of ranges) to activate it, then Right click, and select 'Data Ranges'; that hits this dialog:
chart2/uiconfig/ui/tp_RangeChooser.ui: <property name="label" translatable="yes">Data Range</property>
It would be fantastic to have two extra buttons in there (on the right?) with some pretty UI icons to extend all the ranges down and or right =) [ I suspect the common use-cases ].
This has been fixed recently as part of bug 70609. Right now it is limited to ranges with more than 10k cells and we plan to switch to dynamic shrinking (therefore when we fetch data we build the intersection data range with the chart range and use that) which will fix it even for larger ranges. That is tracked as bug 55697.
I'm not sure if this expand range feature is still necessary.
Oooh - nice =) glad to see that fixed. I imagine shrinking to the size containing actual data is rather important inside the chart itself ;-) but hopefully we can load/save/preserve a much larger range that can subsequently be filled with data =)
if so; marking this closed...
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyInteresting SkillCpp TopicCleanup)