labels on x axis from vba is acting weird

  • Thread starter adullam04-excelgoogle
  • Start date
A

adullam04-excelgoogle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic chart problem 1
Excel automation, change Category (X) Axis Labels, VB6 1
reverse axis not working as before... 0
Changing Category (x) axis labels for radar charts 2
Date values not appearing correclty in the x-axis 1
chart x axis labels show up as range 1
Loop to create charts 1
How to make chart embedded in active sheet? 5

Top