Let’s say this is my table:
Name Vesting months Locked Tokens Tokens monthly
Marketing 120 0 1000 8,3333
Investments 120 0 600 5
Team 48 365 500 10,4166
Sum 2100 23,7499
My goal is to introduce a chart to my investor, showing how much tokens will be released over every month until they reach 100%.
Can I do it somehow automatically or need to copy every type of chart over again and create a big table with values added?
Better to post a sample spreadsheet with the charts to show what you mean and also to explain where the new data will go.
To add to your question, click the pencil icon to edit it and then the up-pointing arrow icon to upload your sample. Cheers, Al
https://ask.libreoffice.org/uploads/short-url/omMlzc26euKXULnKggksJ7XNh4U.ods
One header row, one column of complete dates, values below values, text below text, no empty rows, no empty columns. Rows in random sort order. Very simplistic and similar to a database table.
The pivot table on same sheet is derived from the flat list. First I created a pivot with dates and categories as row fields, persons as column field. Finally I grouped the dates by months and years and added a pivot chart
Are you really sure you want to do it in Writer? You tagged writer (as you did for all your other questions). Your problem is probably easily solved in Calc. By using an incorrect tag, you don’t reach immediately the best contributors. Please, retag or, if you don’t know how to do it, ask somebody to do it on your behalf.