I've imported an Excel spreadsheet containing a chart into Google Sheets.

Excel displays my axis like this: enter image description here

After importing the xlsx into Google Sheets the Axis displays like this:

enter image description here

I can get Google Sheets to display the Axis labels the way I want by unselecting "Treat Labels as Text" in the Google Sheets chart options.

Is there a way that I can set something in the xlsx so that "Treat Labels as Text" is automatically deselected by Google Sheets after importing the spreadsheet?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.