Copying graphs to different file changes x-axis

asked 2020-10-17 19:18:01 +0100

ostbits gravatar image

My x-axis is a number. When I copy the graph to a new spreadsheet, the x-axis format changes to a date. For example, 1993 changes to 06/15/1993.

When I copy the graph to a new sheet, the x-axis stays to same, but when I export the sheet as a jpg, I get the first sheet exported, not the current sheet.

Any way to copy a graph and retain the x-axis format? Or to export an individual sheet as a jpg and not to always revert to the initial sheet?

edit retag flag offensive close merge delete

Comments

Can you upload an .ods type sample file here?

Zizi64 gravatar imageZizi64 ( 2020-10-17 20:32:44 +0100 )edit

There doesn't seem to be anyway to upload a file here (please correct me if I'm wrong). I uploaded the file to my website here

ostbits gravatar imageostbits ( 2020-10-17 20:41:33 +0100 )edit

Edit your original question. There is attachment icon, use it.

Zizi64 gravatar imageZizi64 ( 2020-10-17 20:56:14 +0100 )edit