How do I create a page with several graphs based on monthly inputs
Thank you Mariosv, However, I still do not understand what to do. Here is a partial copy of my chart so far. But I want to have:
- Have the data dates for the various chart dates.
- Also I would like as I add data for the chart to automatically change reflecting the new data.
- Finally how do I get the % calculations to automatically show red for going down or green for going up.,
Could you help a bit more - it would be appreciated.
Umpact of US Tariffs working help.ods (28.6 KB)
See Calc guide (7.5) in English documentation II | LibreOffice Documentation - LibreOffice User Guides
Chapter 3 Creating Charts and Graphs.
At first glance, the range in your sample, mix several data type. The source for chart is better, as table, as can be seeing in the guide.
ask119100.ods (33.1 KB)
I transformed your data into a flat list on sheet “Records”.
Below the first row of column labels, there is one column of item names, a column of dates and a column of values.
I sorted this flat list randomly in order to demonstrate that my solution does not depend on any order of rows and columns. You don’t need to enter the right value at the right crossing between item name and date. Just insert a new row for a new record and enter the item and the value of the day.
The sheet named “Pivot” contains a pivot table derived from the original list. Basically, it converts the flat record set back into a cross table similar to your original one. If you ever enter more than one value for the same item at the same day, the pivot will calculate the average of these values. I set up the pivot to show the differences in percent compared to the same item at previous date. The result are the same as with your formula.
The pivot grows as you enter new records with new items and dates. It is a matter of seconds to group the pivot by months, quarters and years (click a date cell in the pivot and call Data>Group>Group…).
The pivot chart was a matter of 3 clicks. I selected any cell in the pivot, then the chart button on the toolbar and clicked OK.
After editing the source data, right-click>Refresh the pivot table which will rebuild the whole table. The pivot chart will follow.
https://help.libreoffice.org/25.2/en-US/text/scalc/guide/datapilot.html?DbPAR=CALC
2 Likes