Apache OpenOffice (AOO) Bugzilla – Issue 31675
Can't add information from several parts of a chart in a single diagram
Last modified: 2013-02-24 21:19:20 UTC
To create a diagram is necessary to have the set of data grouped, that is, for example, the X axis values in the first column, then the first figures in the second column, the second in the third one, and so on. --------------------------- | A B C D E | 1 | date foo bar baz narf| 2 | 01 32 32 45 45 |<- this is the selected data for the diagram 3 | 02 12 456 56 65 | 4 | 04 45 65 45 65 | --------------------------- This works well if I want to have in my diagram four data (foo, bar, baz and narf ; A1:E4) indexed according to the dates. But what if I want only baz and narf in the diagram while keeping the dates ? The only way to do this was to modify my chart this way : ----------------- A B C | D E F | 1 date foo bar | date baz narf| 2 01 32 32 | 01 45 45 | 3 02 12 456 | 02 56 65 | 4 04 45 65 | 03 45 65 | ----------------- and I selected D1:F4 for my diagram, which is not very elegant. It would be interesting to have the possibility to add data to a graph from several non-contiguous columns (or lines) : ------- ------- ------- | A | B | C | D | E | 1 | date| foo | bar | baz | narf| 2 | 01 | 32 | 32 | 45 | 45 | 3 | 02 | 12 | 456 | 56 | 65 | 4 | 04 | 45 | 65 | 45 | 65 | ------- ------- ------- ^ ^ ^ | | this is the second set | | | this is the first set of | data to represent in the | particuliar diagram | this is what the X-axis shows
Hi, you can do it already. Use the Ctrl-key while selecting the data in column A, C and E. If you enter the ranges directly into the range-field, you have to put a semicolon between the different parts.
Ok, I'm sorry for this already-implemented enhancement request, I didn't find any information about how to do that either in the doc or on the net... However, is there a possibility to have the X axis data note in the first column ? ------- ------- -------- | A | B | C | D | E | 1 | foo | bar | date| baz | narf | 2 | 32 | 32 | 01 | 45 | 45 | 3 | 12 | 456 | 02 | 56 | 65 | 4 | 45 | 65 | 03 | 45 | 65 | ------- ------- -------- ^ this is the X axis data BTW, maybe there's a better place to ask this question ? Thank you
The x-Axis data series is always the left (or upper) one (for OOo1.1). But your wish is already in the feature wish list http://graphics.openoffice.org/chart/featurewishes.html So you can close this issue. You can use the forum http://www.oooforum.org/ or the mailinglist users@openoffice.org to get help or have look at your Native Language Project. You can reach them from the OOo-home http://www.openoffice.org.
kla->shtrom: You agree with regina? kla->regina: Thx, great
closed