Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in using Chart.ApplyCustomType for Excel 2007
Hi,
I have been using following code :- _Chart chart = chartobject.GetChart(); if(3 == m_numAxis) { CString strTemp = _T("Lines on 2 Axes"); // code for creating Lines on the 2 vertical axes of the chart VARIANT var; var.vt = VT_BSTR; var.bstrVal = strTemp.AllocSysString(); chart.ApplyCustomType(21, var); VariantClear(&var); } else chart.SetChartType(74); It is working properly if Office 2003 is installed but for Excel 2007, ApplyCustomType throws an COleDispatch exception. I searched for it on the msdn and also on the net but could not find any sol. Could you provide me the links where I can get much information for chart object and its functions. Thanks in advance for providing an early solution. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in using Chart.ApplyCustomType for Excel 2007
I have been waiting for reply for last 4 days, but it is disgusting to see
there is not even a single reply by anyone. Is there nobody who can help me ? "Sumit" wrote: Hi, I have been using following code :- _Chart chart = chartobject.GetChart(); if(3 == m_numAxis) { CString strTemp = _T("Lines on 2 Axes"); // code for creating Lines on the 2 vertical axes of the chart VARIANT var; var.vt = VT_BSTR; var.bstrVal = strTemp.AllocSysString(); chart.ApplyCustomType(21, var); VariantClear(&var); } else chart.SetChartType(74); It is working properly if Office 2003 is installed but for Excel 2007, ApplyCustomType throws an COleDispatch exception. I searched for it on the msdn and also on the net but could not find any sol. Could you provide me the links where I can get much information for chart object and its functions. Thanks in advance for providing an early solution. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 11 x 17 chart printing problem | Charts and Charting in Excel | |||
Problem copying Chart and Data from Excel 2007 | Excel Discussion (Misc queries) | |||
ApplyCustomType in Excel 2007 | Excel Discussion (Misc queries) | |||
2007 Excel Chart Problem | Excel Discussion (Misc queries) | |||
Calling ApplyCustomType for Excel 2002 in C# | Excel Programming |