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

A

AccessQuestion

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Move Chart with Text 0
I figured out the issue thank you. 0
Can not get Excel macros to save chart format -lost in space! 5
Can not get Excel macros to format/save charts--help??? :((((( 2
Macros for figure borders 1
Changing the chart name 1
Finding the proper style field and the numbered paragraph value within the style 0

Top