+ Reply to Thread
Results 1 to 2 of 2

VBA to push out pie chart slices

Hybrid View

  1. #1
    Registered User
    Join Date
    02-16-2005
    Posts
    5

    Unhappy VBA to push out pie chart slices

    I work in Access almost always and this is an automation question. I have found that I need a chart for an Access Application i am developing and everything so far is working well. I create the chart in excel with information from Access. The exploded pie chart looks the best and displays the data the best for what i need it to. I just cannot find out how to push the pieces of the pie out farther with the VBA code. Does anyone know what code would push the pie slices out futher?

    Thank You,
    Chester

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    recording a quick macro, I get,
        ActiveSheet.ChartObjects("Chart 1").Activate
        ActiveChart.SeriesCollection(1).Select
        Selection.Explosion = 50
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. chart template that updates when data changed
    By debl in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-24-2008, 05:32 PM
  2. Unexpected Behavior from Worksheet to Unembeded Chart
    By gwright1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-01-2008, 06:47 AM
  3. PivotChart filtering and chart type problem
    By php219 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2007, 03:55 PM
  4. How to Select Colors for Pie Chart Slices?
    By Ingeniero1 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-25-2007, 07:57 AM
  5. Going insane!
    By kik in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-31-2007, 08:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1