You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/10/26 21:45:51 UTC

[Bug 123555] New: Added chart line can disappear if target data is for secondary axis

https://issues.apache.org/ooo/show_bug.cgi?id=123555

            Bug ID: 123555
        Issue Type: DEFECT
           Summary: Added chart line can disappear if target data is for
                    secondary axis
           Product: Calc
           Version: 4.0.1
          Hardware: PC
                OS: Windows XP
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: wrightash@hotmail.com
                CC: issues@openoffice.apache.org

There needs to be a choice box in Data ranges... to select either the primary
or secondary axis.

In the attached file the data is 'real' and a simplified version of a much more
complex chart which had more grid lines etc.

The requirement is to extend the red graph in a different colour for the next
year, (2013)

Relevent factors:
  The red graph uses the secondary axis.
  The primary axis does not include zero

When a new set of data ranges is added to make a new line, 
     Name at E1
     x-values   $A$44:$A$90
     y-values   $C$44:$C$90
             no line appears because it has been assigned to the primary axis.

Work round:
To make the new line visible, you need to 
     set the minimum of the  y-axis controls to zero,
     reset the properties of the line to secondary axis
     reset the minimum of the y-axis to its former value
   Not nice.
The choice between primary and secondary axes is a property of the data range
setting, and, once a primary axis exists, should be an option.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123555] Added chart line can disappear if target data is for secondary axis

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123555

Edwin Sharp <el...@mail-page.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |elish@mail-page.com
     Ever confirmed|0                           |1

--- Comment #2 from Edwin Sharp <el...@mail-page.com> ---
Add data series for year 2013 portion doesn't work.

AOO410m1(Build:9750)  -  Rev. 1525015
Rev.1525015

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123555] Added chart line can disappear if target data is for secondary axis

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123555

--- Comment #3 from wrigh <wr...@hotmail.com> ---
Apologies for poor clarity: The 2013 section is created by Add..., but off the
displayed range because it is scaled to the primary axis.
The non-obvious work round given corrects this.

The error is independent of which entry in the table is selected (excerpt from
help file below)

It is not fulfilling the help file statement under 
"Organising data series 
  .....
Click Add to add another data series below the selected entry. The new data
series has the same type as the selected entry."

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123555] Added chart line can disappear if target data is for secondary axis

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123555

--- Comment #1 from wrigh <wr...@hotmail.com> ---
Created attachment 81826
  --> https://issues.apache.org/ooo/attachment.cgi?id=81826&action=edit
ods file with graph ready for testing as in text.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.