Ask Your Question
0

Updating pivot table data range [closed]

asked 2015-07-03 20:56:46 +0100

gbilodeau gravatar image

updated 2020-08-22 21:01:15 +0100

Alex Kemp gravatar image

This is a follow-up question to http://ask.libreoffice.org/en/questio...

I'm using LibreOffice Calc 4.3.1.2 on MacOS Yosemite, all English.

I have a very simple data set: column A is a date-time (YYYY-MM-DD HH:MM:SS) and column B is a quantity (number). I have created a pivot table with date-time as a rowfield, average quantity as datafield, and grouped data by day. I have also created a line graph based on the pivot table output.

My data set has since grew: the pivot table was created using a data range of A1.B1:A100.B100, it now contains data up to A200.B200. I want two things:

  1. Update my pivot table to consider this new data range
  2. Update the graph to consider the updated pivot table data

I could obviously recreate both the pivot table and graph, but I would like this to be easier. Can this be done otherwise?

Thanks again!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-22 21:01:27.474637

1 Answer

Sort by » oldest newest most voted
0

answered 2015-07-03 23:43:14 +0100

m.a.riosv gravatar image

updated 2015-07-04 23:01:37 +0100

For the pivot table:
Right click on the PT
Select edit layout
Expand Source and Destination
Change the last row of the selection

For the graph, please take a look in: how-to-adjust-a-x-and-y-axis-ranges-on-a-chart-created-in-calc

edited: 2015-07-04

The best for PT is use ranges with name, they are easy to modify, and set up the option:
Menu/Tools/LibreOffice calc/General - Expand references when new columns rows are inserted

The use of range names allow to have two PT with different configuration on the same data.

edit flag offensive delete link more

Comments

Works like a charm, thanks. Can we push this a step further: as soon as a new row is added to the raw data set, could the pivot table be automatically updated? Something like a dynamic data range?

gbilodeau gravatar imagegbilodeau ( 2015-07-04 20:06:56 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2015-07-03 20:56:46 +0100

Seen: 1,863 times

Last updated: Jul 04 '15