VBA Graph Formatting

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

With help and guidance from @Andy Pope at this posthttp://www.excelforum.com/excel-prog...bar-chart.html I've been able to put together a short script (below) which creates a 'Stacked Bar' chart'.

Please Login or Register  to view this content.

I'm now looking to extend this a little by including further formatting and customisation of the chart.

I thought I'd start off relatively simple by reversing the order of the 'y' axis', and so through recording this, I know that I need to include the following line of code:

Please Login or Register  to view this content.

As you can see for the script above I've tried to implement this line, but when I run the macro I receive a '438' Run time error and I'm not sure why.

I just wondered whether someone may be able to look at this please and let me know where I'm going wrong.

Many thanks and kind regards

[Izandol]

That line must be after the first 'End With' line because it refers to a property of the Chart, not the Series.

[hobbiton73]

HI @Izandol, thank you very much for taking the time to reply to my post.

I've made the changes as you suggest, but unfortunately I'm still receiving the same error.

Kind Regards

[Izandol]

Please post revised code for checking.

[hobbiton73]

Hi @Izandol, please find my revised code below:

Please Login or Register  to view this content.

Many thanks and kind regards

[Izandol]

This is my fault - I did not notice one of your With blocks. Code must be:

Please Login or Register  to view this content.

[hobbiton73]

Hi @Izandol, you have absolutely no need to apologise, your help is gratefully received and the solution works great.

All the best and kind regards