Ask Your Question
0

Updating pivot table data range

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

gbilodeau gravatar image

updated 2015-08-24 21:19:36 +0200

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

m.a.riosv gravatar image

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

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,310 times

Last updated: Jul 04 '15