Issue 126654 - Cells in hidden columns are excluded from a chart
Summary: Cells in hidden columns are excluded from a chart
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 127386 (view as issue list)
Depends on:
Blocks:
 
Reported: 2015-11-14 12:31 UTC by gebbber
Modified: 2017-04-08 17:47 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description gebbber 2015-11-14 12:31:27 UTC 
A scatter plot refers to a column of data for its second series of 'Y' values.  When the column is hidden by right-clicking the column title and selecting 'Hide', the graphical depiction of the data is also removed from the plotted chart.
Comment 1 Regina Henschel 2015-11-14 12:48:31 UTC 
Show the column. Double-click chart to switch to edit mode. Select the data series, which belongs to this column. Open its format dialog (context menu or 'Format selection'-icon). Find the checkbox 'Include values from hidden cells' on the 'Options'-tab. Check it. OK. Back to the table hide the column. Notice, that the values are still shown in the chart.

Because it is not usual, that hidden values are shown in the chart, this checkbox is off as default.
Comment 2 mroe 2017-04-08 17:47:23 UTC 
*** Issue 127386 has been marked as a duplicate of this issue. ***