Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Can combine chart with control button in Excel 2007?

Latest post Sun, Mar 16 2008 12:23 AM by homt398. 2 replies.
  • Sat, Mar 15 2008 11:02 PM

    Can combine chart with control button in Excel 2007?

    Hi, all 

    Can combine chart with control button in Excel 2007, like the  follow gif show in excel 2003.

    hope chinese language can't make you mad.


    Filed under:
    • Post Points: 21
  • Sat, Mar 15 2008 11:41 PM In reply to

    • Jon Peltier
    • Top 50 Contributor
    • Joined on Thu, Jan 17 2008
    • Massachusetts
    • Posts 13
    • Points 309
    • MVP

    Re: Can combine chart with control button in Excel 2007?

    I don't see any control on your chart.

    Excel 2007 lets you use Forms toolbar buttons in conjunction with a chart. You can embed such a button in a standalone chart sheet, but no longer in an embedded chart. For use with an embedded chart you are encouraged to simply embed the button on the worksheet near or over the chart.

    Use a 2D chart instead of a 3D chart. Your chart shows some of the distortion inhereent in 3D charts. All of the values are exactly equal to integers, but the chart makes them look somewhat smaller, and even closer inspection is not really sufficient to convince the user otherwise.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    Peltier Technical Services, Inc. - http://PeltierTech.com
    _______

    • Post Points: 21
  • Sun, Mar 16 2008 12:23 AM In reply to

    • homt398
    • Top 50 Contributor
    • Joined on Tue, Jan 15 2008
    • Peking, China
    • Posts 12
    • Points 167

    Re: Can combine chart with control button in Excel 2007?

    Hi, Jon

    really thanks for your reply.

    sorry, i  just means Form buttons :)

    i heard someone can embed button in chart 2007, and i confuse how he can do it, so i'm here to confirm the answer.

    BTW, thks your suggest in using 3D chart. 

    www.officefans.net

    Jonathan Kuo

    Regards

    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.