Ask Your Question

How can I change the x-axis format on an imported excel chart? [closed]

asked 2013-07-11 05:34:45 +0200

dennis gravatar image

I have imported a spreadsheet (including a chart) from my windows version of excel, into my mac version of libreoffice (calc). Everything is fine, except that the x-axis format of the chart. In excel, it was setup to have the x-axis in date units. Whenever I access the chart in libreoffice, the x-axis is in a numerical format (probably a date conversion into numerics). When I edit the x-axis, I uncheck the "source format" button. This temporarily fixes the problem. When I re-open the spreadsheet, the chart once again has the x-axis in numeric terms. The "source format" button is once again checked. How do I permanently keep the "source format" button unchecked? It's important to me to have the x-axis in date format for this chart. Is this fixable?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 21:25:48.194821

1 Answer

Sort by » oldest newest most voted

answered 2013-07-11 16:04:05 +0200

ROSt52 gravatar image

This sounds like a bug. Should you not get a better answer, please file a bug report under:

As a workaround I would create the chart new in Calc; this could be the fastest way.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-07-11 05:34:45 +0200

Seen: 255 times

Last updated: Jul 11 '13