Issue 72995 - Allow angle settings that lead to vertical lines
Summary: Allow angle settings that lead to vertical lines
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-12-29 15:39 UTC by Regina Henschel
Modified: 2013-09-25 20:41 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Excel document with 3D chart (23.50 KB, application/
2007-12-21 00:30 UTC, Regina Henschel
no flags Details
OOo document to try to get same chart as in Excel (20.03 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-12-21 00:32 UTC, Regina Henschel
no flags Details
Basic Library with Macro UprightChart (3.51 KB, application/x-compressed)
2010-01-03 17:31 UTC, Regina Henschel
no flags Details
Document with 3D Column Chart (22.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-01-03 17:32 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Regina Henschel 2006-12-29 15:39:54 UTC
In Excel the rotation always acts in that way, that the vertical lines of the
column boxes remain vertical, so that the lines have no stairs. If you will
achieve such vertical lines with the new chart it is difficult. If x- and
y-angles are given, you need decimal z-angles, which are not possible. An
alternative could be, to provide a button "align vertical" and use such angles
internally. You will need it too, for correct importing of Excel charts.
Comment 1 kla 2007-01-02 11:27:17 UTC
@IHA: Maybe a good idea.
Comment 2 IngridvdM 2007-01-04 17:12:09 UTC
Thanks Regina. I see the problem with the vertical lines. But maybe we should
choose another solution and change the angle interpretation to what Excel does.
I changed the summary to address the root problem.
Comment 3 IngridvdM 2007-09-12 09:10:44 UTC
Isn't this issue solved now with the integration of the right-angled axes
feature - see issue 67754 . Or is there any need for further changes in this
Comment 4 IngridvdM 2007-09-21 12:41:19 UTC
I set this to duplicate of Issue 67754 now.

*** This issue has been marked as a duplicate of 67754 ***
Comment 5 IngridvdM 2007-09-21 12:42:13 UTC
closed as duplicate
Comment 6 Regina Henschel 2007-12-21 00:28:32 UTC
No it is not solved with right angles. I'll attach an Excel document with a
chart and a Calc document with the same data and a picture of the Excel chart.
(Importing the Excel document doesn't help, because import of 3D charts is still

Now try to make an OOo chart, that looks like Excel's chart. You cannot get it
by entering the rotation value, although you can calculate them (see issue
72994), because you cannot enter decimal values. Try to get it by dragging it
with the mouse in rotation mode. You will not be able to get vertical lines
without steps, at least I couldn't it.

Right angle is no option, because then the x-axis is horizontal.
Comment 7 Regina Henschel 2007-12-21 00:30:16 UTC
Created attachment 50512 [details]
Excel document with 3D chart
Comment 8 Regina Henschel 2007-12-21 00:32:04 UTC
Created attachment 50513 [details]
OOo document to try to get same chart as in Excel
Comment 9 Regina Henschel 2010-01-03 17:31:28 UTC
Created attachment 66957 [details]
Basic Library with Macro UprightChart
Comment 10 Regina Henschel 2010-01-03 17:32:12 UTC
Created attachment 66958 [details]
Document with 3D Column Chart
Comment 11 Regina Henschel 2010-01-03 17:45:56 UTC
I have uploaded a Basic Library containing the macro UpRightChart. Take a Column
chart in 3D view. Use the angles X=20°, y=30°, Z=10° for example, uncheck
Perspective and uncheck "Right Angles". Try to get nice vertical lines for the
boxes by entering a Z angle value or by rotating the diagram with the mouse.

Now import the library, select the chart and execute the macro UpRightChart. You
will notice the difference immediately.

The macro is only for 3D Column charts and will not work correct for other chart
types. I do not try to make a solution, which can be put directly into the code.
But I want to show you, what this issue is about.