Forum Discussion
Setting Date/Months on X Axis
I have a simple table with months in the first column then data in the next few columns. I create the graph and across the bottom X axis I want the months for 2022 from Jan to Sep. The X axis options...
Could you post a screenshot of the data, or better, attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Here are a couple of screenshots. The first showing the spreadsheet with the right menu screen for the X Axis. The second is a screenshot from an online Microsoft site showing what should be available.
Thanks. It looks like your chart is an XY Scatter chart. I'd change it to a Line chart. You should then have the options shown in your second screenshot.
- You are a superstar mate. Works like a charm. Thanks very much for sorting this out. Very much appreciated.