ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   labels on x axis from vba is acting weird (https://www.excelbanter.com/excel-programming/348569-labels-x-axis-vba-acting-weird.html)

[email protected]

labels on x axis from vba is acting weird
 
I have some vba that I use to generate charts.
Here is the first few lines:
Application.ScreenUpdating = False
Sheets("Data (altered)").Select
Range("r8:r12,t8:v12").Select
'Range("t8").Activate
Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("data
(altered)").Range("r8:r12,t8:v12"), _
PlotBy:=xlColumns

The problem is that the value of t8 is supposed to be a label along the
x axis. However, the label appears as a concatenation of t8 and t9,
where as the other labels, u8 and v8 works fine.

Why would this happen?

TIA



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com