none
excel 2007 with drill down pie charts

    Question

  • Hi,

    I have a table (technologyname, Quarter, Count).

    I have to create a pie chart with drilldown approach, how i can do this excel 2007?

    any exe's for performing tasks.

    Thanks,

    Rao

    Friday, June 25, 2010 6:20 AM

Answers

  • Hello Rao,

    If I understand you correctly, you want to create a drill down pie chart in UI. If yes, you could go to click Pie button on Charts group of Insert tab.

    To create a chart programmatically, you could record a macro, and will see a general syntax. You could convert VBA code to .NET one.

    If you have any concern for this post, please feel free to follow up.

    Best regards,
    Bessie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Marked as answer by Bessie Zhao Friday, July 02, 2010 2:00 AM
    Monday, June 28, 2010 9:56 AM

All replies

  • Hello Rao,

    If I understand you correctly, you want to create a drill down pie chart in UI. If yes, you could go to click Pie button on Charts group of Insert tab.

    To create a chart programmatically, you could record a macro, and will see a general syntax. You could convert VBA code to .NET one.

    If you have any concern for this post, please feel free to follow up.

    Best regards,
    Bessie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Marked as answer by Bessie Zhao Friday, July 02, 2010 2:00 AM
    Monday, June 28, 2010 9:56 AM
  • How to add drilldown to Excel's Charts Part 1: http://www.youtube.com/watch?v=-Uu2WqDxLdk
    • Proposed as answer by CHatmaker Sunday, April 22, 2012 1:51 AM
    Thursday, September 15, 2011 4:34 PM