I used to use MS Excel and MS Powerpoint to do my job, but now I switched to Linux and OpenOffice. I have lots of data in Calc and I need to make graphs from these data in Calc. Then, I need to make presentations with Impress which include these graphs in my presentations. I need these graphs in my presentations updated as I update the spreadsheet in Calc.
In Excel and Powerpoint, I made the spreadsheets in Excel first, then I created graphs based on the data in the spreadsheets, also in Excel, then I copied these graphs and used "Paste Special" in Powerpoint to paste my graphs into my presentations. The graphs in my presentations were automatically updated as I updated the data in Excel.
How to do it in Calc and Impress? Thanks.
OpenOffice 3.3 on Ubuntu 11.10