Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Change Graph Type

    Hi,

    I have a table with with following columns
    Column A : Week
    Column B : No of Cases
    Column C : % with SLA

    I have created a Line and Column on 2 Axes graph for the same. I am check is is possible to have the options buttons Line Graph and Bar Graph and on selecting one of them the graph changes accordingly.

    For eg. if i select Line Graph option button the graph changes to "lines on 2 Axes" graph. If I select Bar Graph button the graph changes to "Line and Cloumn on 2 Axes" graph.

    I have attached file with a sample, do let me know if this is possible.

    Thanks
    Baiju
    Attached Files Attached Files

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Is this going in the right direction

    Example using Form Option Buttons in a Group Control
    With Macro attached to each button

    See Attached
    Attached Files Attached Files
    Andrew

  3. The Following User Says Thank You to AndrewKKWalker For This Useful Post:

    Baiju G Nath (2011-11-09)

  4. #3
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Andrew,

    Thanks for the, this is working perfectly. Just a couple of queries.

    How do i modify the macros if i need to change the graph type?
    If I protect the workbook and click ont he button the macro throws up an error. How do i fix that?

    Regards
    Baiju

Posting Permissions

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