Apache OpenOffice (AOO) Bugzilla – Issue 45495
Freezing charts thus they are independantly from actual data cells
Last modified: 2013-02-24 21:20:57 UTC
Hello, I have the following 'problem' with openoffice. I have a large collection of data that I import from a CSV file. The format is something like this, as an example: name,age,height,weight,salary,etc... I would like to make a series of charts about the people, and I would like them to all be sorted. So there would be one chart with all the people and their ages, sorted by age. Then another chart with the names and heights, sorted by height, and so on. Currently, this seems to be impossible, because the moment you sort the cells on one column, all the charts change and so you can never have all the carts nicely sorted. I suppose it would be possible to have multiple data collections, like so: name,age name,age namge,age name,weight name,weight name,weight But that gets complicated, messy, and worst of all is difficult to import from a CSV file. Perhaps the best way around this would be some way to unlink chart sorting from actual cell sorting. Does that make sense? Thankyou for your time, David N. Welton
.
I think that it's a good idea :-) This issue is always UNCONFIRMED ?
->davidnwelton: Do you want to have the age or the height as x values at the axis? If these are numbers you should try the xy (scatter) chart. You will be asked wether you would like to sort the x values -> that should do the trick for you in a first step. (I know that there is still a bug in the sorting of x values in the old chart, but this is targeted to be fixed in the ongoing chart reimplementation ). So my question is: Do you need more than sorting of x values?
added keyword needmoreinfo
I'm not sure what additional information you need... I don't care about one particular chart. I want to make several different charts from the same data by: * Sorting the data. * Creating a chart. * "Freezing" that chart * Sorting the data a different way. * Creating another chart, while leaving the first chart unchanged. * etc... It would be quite handy, I think.
I assume that the data you want to sort is numerical, right? Then you can use the XY chart type to display and use your sort criteria data as x values. In xy charts the data points will be displayed on the naturally sorted x axis. When you want to connect your data points with lines you will want to sort the data poitns itself according to x values of course. But this can be done. The old chart does ask you to sort the data when creating an xy chart (bad design here, soory). A bug here leads to corruption of the sorting only when underlying data is changed. In the coming reimplementation of the chart you can change the sorting of the data points for xy values even after creation and will be saved and kept and not distorted by data change notifications. Maybe you want to check a preview download of the coming changes in chart here: http://graphics.openoffice.org/chart/chart.html If this does not fit your needs I still don't get what you want to do.
If you want to freeze a chart that you have created already please use copy and Menu->Edit->Paste Special ->GDI Metafile. Then you get a screenshot of the chart that will not change anymore when the underlying data is changed.
closed as works for me
Created attachment 72334