Programmatically creating chart with hour value on X-axis but not plotted as a series

Hi, I'm a bit stumped by the following and was hoping somebody could help.

I'm looking to programmatically create a chart of the type shown on top in the attached image.

That is with the hours from 0 to 23 showing on the x-axis but not plotted as such.

When I try to create this programmatically using the code below the chart showing on the bottom is being produced.

Here's the simple code I am using:

Please Login or Register  to view this content.

Same chart data range for both charts is showing in 'Select Data'. Both obviously xlLine charts.

The 2nd chart obviously has the 2nd series that I do not need. If I remove this series, the x-axis value continue to plot from 1 to 24

I'm probably missing something obvious but I cannot find what it is.

Thanks in advance for any advice.
Orson.

Hi Andy, many thanks for the impressively fast response

I see what you've done there and many thanks for that, I will gladly pinch it on you.

I do find it rather strange that there does not appear to be any programmatical distinction that you can specify on initial creation of chart to ensure you get the version you want.

Rather, you're obliged to make these post-creation changes.

I've reviewed the macro recorder output for a differentiator when I select both of these chart options in the GUI in turn and I can't see anything there.

Thanks again, this will allow me to get on with things now, will have to re-purpose for other sheet requirements also.

Rgds
Orson.