You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other programmers’ questions, win occasional prizes given to our best members, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
I am creating Pivot Charts in Excel 2007 using VBA. The problem is that even though I set the ActiveChart.ChartType = xlLine, it defaults to xlLine with Markers. I've changed my order of operations and every other trick I know of. Has anyone else seen this issue or know of a soloution?