I am getting following error
No appropriate method, property, or field Font for class Interface.Microsoft_Excel_12.0_Object_Library.ChartTitle.
Error in ==> xlsgraph at 342
Excel.ActiveChart.ChartTitle.Font.Bold = 1;
is it because of Office 20007
Comment only
12 Oct 2010
xlsgraph
Creates graphs from existing Excel sheet containing column data.
-------------------------- Excel2007 -----------------------------
Hi,
see below how I got it working with Office2007 (and Office2003).
I changed these lines:
Do not use
Excel.ActiveChart.SeriesCollection(1).Delete;
but
try %Office2007 HK
for zz = 1:nr
Excel.ActiveChart.SeriesCollection(1).Delete;
end
end
Has to be done twice in the code.
I commented these lines:
% Excel.ActiveChart.PlotArea.Select; %HK
% Excel.Selection.Border.ColorIndex = 16;%HK
% Excel.Selection.Border.Weight = 1;%HK
% Excel.Selection.Border.LineStyle = 1;%HK
% Excel.Selection.Interior.ColorIndex = 0;%HK
% Excel.Selection.Border.ColorIndex = 2;%HK
% Excel.Selection.Border.Weight = 1;%HK
% Excel.ActiveChart.Axes(1).Crosses = 1; %HK
% Excel.Selection.Border.ColorIndex = 1; HK
% Excel.Selection.Border.Weight = 1; HK
% Excel.ActiveChart.Legend.LegendEntries(i).LegendKey.Border.ColorIndex = colors(k); HK
% Excel.ActiveChart.Legend.LegendEntries(i).LegendKey.Border.Weight = 3; HK
% Excel.ActiveChart.Legend.LegendEntries(i).LegendKey.Border.LineStyle= 1; HK
Bye, Hinrich.
5
16 Mar 2010
xlsgraph
Creates graphs from existing Excel sheet containing column data.
Peng Xi
Can you please help me out in drawing the graph on same excel file.
Needless to say that the work is awesome, but I can't spare enough of time on this, as my research will hamper otherwise.
Comment only
25 Mar 2009
xlsgraph
Creates graphs from existing Excel sheet containing column data.
Respecto al problema de Javier Seminario y la solución de Hinrich Koetter
Si teneis Excel en castellaño o español, teneís que sustituir 'R' y 'C' por 'L' (Linea) y 'C' (Columna)
Comment only