Can not figure out the code for the chart layout type I want

AccessQuestion

Guest

Posts: n/a

19th Mar 2010

I am trying to select a specific chart layout in my macro/VB code but
can not tell what to use.

When I use the macro record to record the chart layout type I want to use,
it looks
like this:

ActiveChart.ApplyLayout (5)
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.DataTable.Select

but ApplyLayout (5) does not work when I try to run the macro.
I get an "item with specified name wasn't found" error.

I hope someone can help?? Thanks!
--
mfg2529

« Pareto charts and Run Charts | bars on chart do not match data points »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: How do I type in full figure	Matthew Cavagnaro	Microsoft Excel Charting	0	16th Jan 2007 12:49 AM
Trying to figure out how to format a certain report layout.	kelly d via AccessMonster.com	Microsoft Access Reports	2	13th Nov 2005 09:39 AM
Adding a line Chart Type to a stacked-clustered Chart Type	=?Utf-8?B?RGViYmll?=	Microsoft Excel Charting	2	5th Jan 2005 11:25 PM
Changing layout of Chart in Crystal Reports 9 dynamically from VB.NET code.	Vadim	Microsoft VB .NET	2	10th Mar 2004 05:55 PM
Code to Change Chart Type	Pedro Marques	Microsoft Excel Programming	1	23rd Jul 2003 01:41 PM