Set m圜hart = m圜hart.Location(Where:=xlLocationAsObject, Name:=destinationSheet) Sub yourMethodName()ĭim rngChart As Range, desinationSheet As String This is a kind of note of thanks to all the net users from who I learnt VBA (not expert level yet). you need to make changes in cell values to make it work for you. Here is a nice VBA script for drawing a bar chart.

I'm using a 2007 excel (as I read before in other questions, the 2007 excel chart macro recorder is pretty poor and the problem, I'm talking about might be caused by this), but I'm looking for any good answer that can help solve my problem. I tried to record the macro by different ways such as throught the tool bar in excel (also more ways throught this), throught the keyboard, but none recorded code contains any information, that could distinguish between X and Y axis. What I want (I apologize for such rude formulation, but I just wanted to strictly state, what is my idea): I would like to have a solution, such, that every time I run the macro, I have a different chart, but with the same axis label names, i.e., X-axis: U, and Y-axis: I ĪctiveChart.ChartType = xlXYScatterSmoothĪctiveChart.SeriesCollection(1).Name = '=''I-V char'''ĪctiveChart.SeriesCollection(1).XValues = '=hviezd1!$D$2:$D$193'ĪctiveChart.SeriesCollection(1).Values = '=hviezd1!$E$2:$E$193'ĪctiveChart.Axes(xlValue).AxisTitle.SelectĪctiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = 'I 'ĪctiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = 'U ' I add: code sample (in the code, I removed all unnecessary data, and such, that prevent the macro from running next time). But the vba- macro code does not record any information about the difference between the X and the Y axis, and the result is, that the one axis label is overwritten or, there are two same axis labels in the macro- generated chart. But the problem is I want to set the axis labels on the chart, as I want, so as they have (the same) concrete names, every times I run the macro. Let's say, for simplicity, I'm processing a simple two colunms of data repeatedly and the output is a plot, so I recorded a macro.

Change axis labels excel 2008 for mac