[Libreoffice-bugs] [Bug 114181] FILESAVE XLSX combined chart (Column and Line) X category axis crosses the Y axis at the wrong place and the Y axis major grid disappears.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114181

--- Comment #12 from Adam Kovacs <christo161 at gmail.com> ---
Created attachment 148394
  --> https://bugs.documentfoundation.org/attachment.cgi?id=148394&action=edit
screenshot_114181_excel_vs_calc

The results so far:

If I apply the modification in comment 6, LO import and export will be good in
the case of an existing chart in docx or xlsx file, but if you make a new chart
with LO, save and reload, the X axis will still be at wrong place even in MSO
(as you can see on the screenshot).

If you want to make a new combined chart with LO have to follow these steps:
1. insert menu, chart, column and line, enter a value for the number of lines
2. check if it is needed to check first row or first column as label
3. reorder your dataseries if it is needed (the top ones will be column charts
and the bottom ones will be line charts)
4. Excel make the line charts aligned to secondary Y axis, so you should change
this also (double click on a linechart in LO)
5. Excel put the secondary Y axis to the beginning of the chart, so to switch
the two Y axes in LO, double click to the Y axis on the left and select
positioning and end

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190117/1b963eaf/attachment-0001.html>