+ Reply to Thread
Results 1 to 3 of 3

How to create Multiple Charts with a Click of a Button

  1. #1
    Registered User
    Join Date
    03-11-2020
    Location
    Bloomington
    MS-Off Ver
    2018
    Posts
    22

    Question How to create Multiple Charts with a Click of a Button

    Hi Everyone,

    I'm trying to create a button that automatically creates a new tab and creates charts for the following:

    pic1.png

    and I want the type of chart to be created like below:

    pic2.png

    1) Use the highlighted data to make the chart (not for the first two graphs in row 1 - 7)
    2) Turn that data into this type of bar chart (I'm not sure of the specific name)

    This is the hard part for me to and why I'm requesting your help. I would like this to dynamic (for the lack of a better word). For example, if I were to delete rows 27 - 30, I would like to be able to still create the chart. That's because this is just a template and for different projects, I may have fewer domains.

    Note: I'd prefer if the charts are all on the same tab.

    Code I've tried to use keeps putting the domain number in the bar, but I don't want that. Below is my code:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by excelhelp31120; 04-14-2020 at 02:48 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,410

    Re: How to create Multiple Charts with a Click of a Button

    I created a function to generate a chart using the ranges for series name/category/data.
    It returns the newly created chartobject in case you want to do further formatting of the chart.
    The ranges will use the data to determine the number of rows to use.

    You can chose the output location/size of the chart if too big or small.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-11-2020
    Location
    Bloomington
    MS-Off Ver
    2018
    Posts
    22

    Re: How to create Multiple Charts with a Click of a Button

    Woohoo! Thank you so much!!

+ 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. Create Button Click With 2 Conditions
    By Jhon Mustofa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2017, 05:13 AM
  2. [SOLVED] How to create auto fill & click button
    By Byambadorj in forum Excel General
    Replies: 7
    Last Post: 05-10-2017, 03:50 AM
  3. [SOLVED] How to create Line Charts automatically just in one click?
    By Imran Magsi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-27-2016, 06:07 AM
  4. [SOLVED] create a 'button' to click to clear cells
    By OAKLEY in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-13-2014, 07:12 AM
  5. Hi, How can I create a button that if you click on it, it's displays the
    By netanel99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2013, 12:56 PM
  6. Create worksheet copy with click of button
    By excel_vb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2010, 10:52 AM
  7. [SOLVED] [SOLVED] Create floating button based on button click in menu
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2005, 02:05 PM

Tags for this Thread

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