Summary: | Option to reverse series order for stacked area/column charts | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | gekacheka |
Component: | Chart | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | enhancement | ||
Priority: | medium | ||
Version: | 4.2.1.1 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Attachments: | Example area/column/bar stacked charts for table are in opposite vertical order |
Reproducible with LO 4.3.2.2 (Win 8.1) |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 94696 [details] Example area/column/bar stacked charts for table are in opposite vertical order When presenting both a table of data and a summary stacked chart (stacked area chart, stacked column chart, stacked bar chart), it is difficult to look for corresponding numbers because the chart is in opposite vertical order. Feature request: an option to build the chart with the data in the same vertical order as the source table. Maybe "[ ] Reverse series order". (In contrast to "reverse value order" within a series.) Workaround: manually reverse the order of the data series using the up and down arrows of the "Data Series" tab of the "Data Ranges" dialog. This is tedious and error-prone. (It is also a confusing because the vertical order in the chart is the opposite of the order in the dialog.) Steps to reproduce: 1. Create a stacked area chart 1a. Copy this tab-separated data to a new spreadsheet week w1 w2 w3 w4 new 10 9 8 7 open 10 8 9 8 active 10 7 8 4 review 10 12 9 7 closed 10 13 13 16 1b. Select all the data cells (from 'week' to '16') 1c. Click red 'Chart' button in toolbar 1d. Click 'Area' chart in left column 1e. Click 'Stacked' in top row of charts 1f. Click next 1g. Click "( ) Data Series in Rows" 1h. Click next Actual result: Data table has 'new' on top, 'closed' on bottom. In contrast, stacked chart has 'new' on bottom, 'closed' on top. No option to reverse order (except tedious manually reordering data series) Desired result: Data table has 'new' on top, 'closed' on bottom. Stacked chart has 'new' on top, 'closed' on bottom. 2. Create a stacked column chart 2a. Copy this tab-separated data to a new spreadsheet week w1 w2 w3 w4 new 10 9 8 7 open 10 8 9 8 active 10 7 8 4 review 10 12 9 7 closed 10 13 13 16 2b. Select all the data cells (from 'week' to '16') 2c. Click red 'Chart' button in toolbar 2d. Click 'Column' chart in left column 2e. Click 'Stacked' in top row of charts 2f. Click next 2g. Click "( ) Data Series in Rows" 2h. Click next Actual result: Data table has 'new' on top, 'closed' on bottom. In contrast, stacked chart has 'new' on bottom, 'closed' on top. No option to reverse order (except tedious manually reordering data series) Desired result: Data table has 'new' on top, 'closed' on bottom. Stacked chart has 'new' on top, 'closed' on bottom. 3. Create a stacked bar chart 3a. Copy this tab-separated data to a new spreadsheet week new open active review closed w1 10 10 10 2 5 w2 9 8 6 6 8 w3 7 4 10 5 11 w4 5 2 10 4 16 3b. Select all the data cells (from 'week' to '16') 3c. Click red 'Chart' button in toolbar 3d. Click 'Bar' chart in left column 3e. Click 'Stacked' in top row of charts 3f. click next Actual result: Data table has 'w1' on top, 'w4' on bottom. In contrast, stacked chart has 'w1' on bottom, 'w4' on top. No option to reverse order (but see workaround below). Desired result: Data table has 'new' on top, 'closed' on bottom. Stacked chart has 'new' on top, 'closed' on bottom. (Workaround for #3 only: 3g. double click chart to edit it 3h. right click on y-axis (or its labels), select "Format Axis..." 3i. click "Scale" tab 3j. Enable "Reverse Direction" checkbox However, this puts the x-axis at the top of the chart.) (LibreOffice Version: 4.2.1.1, Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b, 32bit windows XP)