💻 Software
OpenOffice.org calc: how to dynamically update a data range for a graph?
Fresh5 days ago
Mar 15, 20264063 viewsConfidence Score0%
0%
Problem
I have an OpenOffice.org spreadsheet that contains a number of graphs. As I append more data to this spreadsheet, I want to update all the data ranges in those graphs, basically changing to , then to and so on… This is a borig manual work. Is there a way to automatize it with some clever trick? For…
Error Output
A1:A100
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: OpenOffice.org calc: how to dynamically update a data range for a graph?
Low Risk
Unfortunately it cannot be done in Calc. This feature is on the TODO list for the 3.x version. Calc is not able to ignore empty cells. When this feature is added, you can select the entire column or a wider range and ask Calc to ignore empty cells.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix