+ Reply to Thread
Results 1 to 7 of 7

Bar Chart

  1. #1
    Registered User
    Join Date
    04-30-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    72

    Bar Chart

    I have a new Favor/question in 4 tabs will list all closed tasks can any one help me to create a macro that on command 1st creates a bar chart and as we go on second updates it on command.
    Id rather it be on command not running all the time because it tends to crash excel on my pc and slows it down.
    Or if there is another way of having the bar chart update without a Macro that would be excellent..

    I would need the chart to pull the data from the 4 closed tabs.
    The chart should include Data that is entered in Columns D,E,I Columns D & E will be drop down list with the information which users are restricted to only pick from drop down.

    I have attached my Document

    Sorry I know its a lot any help is appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Bar Chart

    Hi gmcgrane,

    Hope you have managed to solve this by now.. if not, can you update some data in those 4 closed tabs.. also let me know where you want the char to appear ? thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    04-30-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Bar Chart

    Hey,
    This is still open havnt got any update apart from what is said above? The chart is to appear on seperate sheet
    Is there any other info needed

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Bar Chart

    Yes..
    can you update some data in those 4 closed tabs.
    ?
    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    04-30-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Bar Chart

    Sorry yes Il add data to the document asap. Not at the pc right now
    thanks for your assistance

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Bar Chart

    Okay.. awaiting your response


    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  7. #7
    Registered User
    Join Date
    04-30-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Bar Chart

    Task_Journal (3) (1).xlsx
    Hey Hope this helps added one or two to the drop down menu does this help.

    Thank You for your patience,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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