Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unable to get the Interior property of the PlotArea class
Hi,
I'm using Microsoft.Office.Interop.Excel and VB.Net with ASP.Net to create an Excel workbook with an Excel chart in a worksheet. Most of the code works that I developed in VBA. The chart is created. But, it fails to find any properties or methods of the PlotArea class. Even though they are "available" in the context menu. This line works: xlApp.ActiveChart.ChartArea.Border.LineStyle = 0 But this fails: xlApp.ActiveChart.PlotArea.Interior.ColorIndex = xlNone with the error message "Unable to get the Interior property of the PlotArea class" (xlNone is a constant) Has anyone run into a similar problem? Thanks, Wendell |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unable to get the Interior property of the PlotArea class
When you run that line does the chart actually have a PlotArea. It wouldn't
for example if no series had yet been added to the chart or if all series had been deleted. Regards, Peter T wrote in message ... Hi, I'm using Microsoft.Office.Interop.Excel and VB.Net with ASP.Net to create an Excel workbook with an Excel chart in a worksheet. Most of the code works that I developed in VBA. The chart is created. But, it fails to find any properties or methods of the PlotArea class. Even though they are "available" in the context menu. This line works: xlApp.ActiveChart.ChartArea.Border.LineStyle = 0 But this fails: xlApp.ActiveChart.PlotArea.Interior.ColorIndex = xlNone with the error message "Unable to get the Interior property of the PlotArea class" (xlNone is a constant) Has anyone run into a similar problem? Thanks, Wendell |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unable to get the Interior property of the PlotArea class
On Sep 2, 10:43*am, "Peter T" <peter_t@discussions wrote:
When you run that line does the chart actually have a PlotArea. It wouldn't for example if no series had yet been added to the chart or if all series had been deleted. Regards, Peter T wrote in message ... Hi, I'm using Microsoft.Office.Interop.Excel and VB.Net with ASP.Net to create an Excel workbook with an Excel chart in a worksheet. Most of the code works that I developed in VBA. The chart is created. But, it fails to find any properties or methods of the PlotArea class. Even though they are "available" in the context menu. This line works: xlApp.ActiveChart.ChartArea.Border.LineStyle = 0 But this fails: xlApp.ActiveChart.PlotArea.Interior.ColorIndex = xlNone with the error message "Unable to get the Interior property of the PlotArea class" (xlNone is a constant) Has anyone run into a similar problem? Thanks, Wendell- Hide quoted text - - Show quoted text - Thanks, Peter! That was the problem. I hadn't added the series yet. Wendell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unable to get the VLookup property of the WorksheetFunction class | Excel Discussion (Misc queries) | |||
Unable to set the XValues property of the Series class | Charts and Charting in Excel | |||
Unable to set the Values property of the Series class | Charts and Charting in Excel | |||
Unable to set the formula property of the series class | Charts and Charting in Excel | |||
Unable to set the XValues property of the Series class | Charts and Charting in Excel |