Any suggestions on how to use VBA to set the Category (X) Axis Lables on using VBA?
When creating a line (xlLineMarkers) chart in Excel using VBA I am not able to program the X axis lables. By default my chart just lables the X axis with 1 - n to represent the number of data points. I tried recording a macro when I manually selected "Source Data" - "Series" on the chart, and then entered in the appropriate range for the Category (X) axis Lables, however when I view the records code it only lists the Values for my SeriesCollection items, and does not have any reference to the change of the lables.
When creating a line (xlLineMarkers) chart in Excel using VBA I am not able to program the X axis lables. By default my chart just lables the X axis with 1 - n to represent the number of data points. I tried recording a macro when I manually selected "Source Data" - "Series" on the chart, and then entered in the appropriate range for the Category (X) axis Lables, however when I view the records code it only lists the Values for my SeriesCollection items, and does not have any reference to the change of the lables.