Chart data table format

[Caliche]

I wanted to record a macro for giving format to a chart's data table. The generated code with the macro recorder was:

ActiveSheet.ChartObjects("Gráfico 3").Activate
"Tabla de datos".Comment.Shape.Select ' Here there is a mistake
Selection.AutoScaleFont = True
With Selection.Font
.Name = "Arial Narrow"
.FontStyle = "Normal"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
.Background = xlAutomatic
End With

but the second generated statement has an error (the statement appears red colored).

Could you tell me please why is this error generated?

Which ones are the VBA statements for formatting a chart's data table (change fornt type,size, etcetera.) ? . Currently using Excel XP.

Thanks a lot for your help.

 

[MartinK]

Strange.
This was really how the recorder recorded it???

Try:
<pre> <SPAN style="color:#00007F">With</SPAN> ActiveSheet.ChartObjects("Gráfico 3").Chart.DataTable.Font
.Name = "Arial Narrow"
.Size = 10
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN></pre>

Martin

 

[Caliche]

Strange.
This was really how the recorder recorded it???

Yes, Martin : that was as the recorder recorded it. It loks very strange to me, too. I did two things:

Created a new chart and run your macro: It worked perfectly.

In the same chart, I recorded a new macro:
- Selected the data table
- changed font type, size, etc. and I got the same error.

Does it depend of the way you select the data table? why does it record something related to comment.Shape and selects it instead of ActiveSheet.ChartObjects("Gráfico 3").Chart.DataTable ?.

May be a charts'guru could answer my doubt. Anyway, thanks a lot for your time.

 

[MartinK]

Hello again,

the macro recorder records usually in a very ineffective way, mainly, it uses selections. But the code should at least compile and contain no syntax errors.

You need to select only in very rare cases, e.g. when copying-pasting data between applications.

The comment object is a result of Range.Comment property. I really don't have clue as to how could chart object contain comments.


You're welcome

Martin