Excel Graph - horizontal axis labels not showing properly

Question

Hi,  I, having problems with an Excel graph.  I've created Horizontal Axis Labels but these are not pulling through to my graph see below.  Any suggestions on how to fix this.

Thanks Allan

Answer 1

It is far too complicated to recreate such a scenario. And if it does not match yours, then our solution will not work for you.

For this kind of requests, please create a sample file with the layout of your original file, filled with sample data and colored cells with the expected result.

At best make a copy of your original file and anonymize the necessary data. For this please download this file

https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAnonymize.bas?dl=1

Open your Excel file

Right-click on the sheet tab

Choose "View Code"

Press CTRL-M

Select the downloaded file and import

Close the VBA editor

Select the cells with the confidential data

Press Alt-F8

Choose the macro Anonymize

Click Run

Upload it on OneDrive (or an other Online File Hoster of your choice) and post the download link here.

https://support.office.com/en-us/article/Share-OneDrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

Then we can look at the file and try to find a solution. Thank you for your understanding.

Andreas.

Answer 2

Hi Andreas

I've uploaded a file which has the problem.

If you look at the chart you can see that the labels on the horizontal axis are 1,2,3.....

However if you open Select Data the horizontal Axis labels are 2020, 2021, 2022...

I have found that if I change the horizontal axis last and then close and save the document it keeps the correct label however if I continue to edit the file or add more data series on the left hand side this is when the horizontal axis changes.

Regards

Allan

https://ascotlloyduk-my.sharepoint.com/:x:/g/personal/allan_maxwell_ascotlloyd_co_uk/EdnEwLbbSpVMjYwE9BPBbiAB0T1ttxIm8y2MDtW-2ZEDKg?e=wIWmCP