Can I have two X Axis in a chart?

asked 2019-05-18 23:51:27 +0200

benchrest gravatar image

This question has been around for many years, but now that I am on 6.3 of calc I was hoping for a different answer. I have many sets of economic and investment data that I would like to be able to compare data. All the data is for the same time period, but a different date scale. Some is daily, some monthly and some quarterly. I would like to have monthly on the bottom and quarterly on the top. Has there been a way to do this added to calc? It would seem to define a 2nd X axis would require a 2nd category in the Data Ranges define. Its not there. I can create a 2nd copy of the x axis one at bottom and one at top but they are the same.

edit retag flag offensive close merge delete

Comments

Would it make sense to rotate the chart 90° to exchange axis? Calc offers 2 Y-axis on which you can spread series (as bar charts). This is just a suggestion, I haven't checked it.

ajlittoz gravatar imageajlittoz ( 2019-05-19 08:04:28 +0200 )edit

Of cause you can have two x-axes. That has been always possible. Perhaps you use a line chart instead of an XY-chart, in case you cannot format the secondary x-axis as you like.

Regina gravatar imageRegina ( 2019-05-19 19:22:54 +0200 )edit