LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Unable to get the VLookup property of the WorksheetFunction class Ayo Excel Discussion (Misc queries) 4 August 6th 08 10:00 PM
Unable to set the XValues property of the Series class Ben Charts and Charting in Excel 7 December 7th 06 10:01 PM
Unable to set the Values property of the Series class rafael garcia Charts and Charting in Excel 1 September 25th 06 04:31 PM
Unable to set the formula property of the series class Malhar Charts and Charting in Excel 1 July 24th 06 05:50 PM
Unable to set the XValues property of the Series class ramkumar_cpt Charts and Charting in Excel 5 November 29th 05 02:13 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"