VBA to show Horizontal Category axes in Charts

[caabdul]

Hi,

Kindly check the attached file.

What change is required in VBA code so that Horizontal Axes Months must be displayed as January, February, March etc instead of "1", "2" and "3".

Consider in the excel table another row containing all months.

[Andy Pope]

You need to assign the XValues property for 1 of the series.
You also need to provide a range that contains the information. You can not just change contents of row 4 as this breaks your formula. So in row 3 enter Jan, Feb, Mar etc.

Please Login or Register  to view this content.

[caabdul]

Thank you, but done this already yesterday!!!