Greetings All
I have a weekly Dashboard Report that I prepare for management that has 3 simple bar charts on it. I had been doing a lot of the work manually but have taken the time to automate the process and I have reached a point that I just cannot seem to find an answer to. The vertical axis has 14 points on it, A-N for different product sources but what I am getting is numbers 1-14. Here is the code for how the entire chart is being populated, and where the values are coming from column V, the Axis labels are located in column U. Can anyone tell me how I can get the labels on my chart like they should?
ActiveSheet.ChartObjects("Ch_UAFKettle").Activate
ActiveChart.SeriesCollection(1).Delete
ActiveChart.SetSourceData Source:=Range("V6:V19")
ActiveSheet.ChartObjects("Ch_UAFKettle").Activate
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection(1).Delete
ActiveChart.SetSourceData Source:=Sheets("Data Staging").Range("V6:V19")
'
ActiveChart.SeriesCollection(1).Select
ActiveChart.SetElement (msoElementDataLabelOutSideEnd)
ActiveChart.SeriesCollection(1).DataLabels.Select
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
I got this code using the Macro Recorder. My other charts do not have this problem because the labels themselves are the numbers 1-6.
Thanks for helping!
Bookmarks