Consulting

Results 1 to 3 of 3

Thread: Powerpoint Combobox to calculatable table - can this be done?

  1. #1
    VBAX Newbie
    Joined
    Jul 2023
    Posts
    2
    Location

    Powerpoint Combobox to calculatable table - can this be done?

    Hi, just joined and I'm hoping you can help.

    I have a spreadsheet that has 10 questions - each of which is to be scored 1-4 based on the respondant's choice. This then feeds in to table which calculates the totals and then plot as chart across 4 axis.

    I work as a trainer and Im trying to make this an interactive document (our delegates dont have full system access at this stage so we want to use Powerpoint.

    I have set up 10 slides each with 4 combo-boxes which score each statement 1-4. Is there a way that these values can be entered in to a table (preferably embedded rather than an external one) so the totals can be plotted?

    I'm sure this is a pretty straightforward thing to do, my experience is in Excel but i cant seem to find anything on Google or Youtube to assist.

    Any help would be GREATFULLY appreciated.

    Many thanks in advance

    Iggy

  2. #2
    VBAX Newbie
    Joined
    Oct 2023
    Posts
    1
    Location
    it is possible to enter the values from the combo boxes in PowerPoint into an embedded table and then calculate totals and plot charts based on those values. Here's a general approach you can follow:

    Create an Embedded Table: Insert a table directly onto your PowerPoint slide. Right-click on the slide, choose "Table," and define the number of rows and columns you need to accommodate your data. Alternatively, you can copy a table from Excel and paste it as an embedded table in PowerPoint.


    Link Combo Boxes to Table: Right-click on each combo box and select "Format Control." Under the "Control" tab, specify the cell link where you want the selected value to be stored. Link each combo box to a separate cell in the embedded table.


    Calculate Totals: In the table, add formulas to calculate totals for each row or column, depending on your desired calculation. You can use formulas like SUM, AVERAGE, or COUNT to derive the totals based on the linked cells from the combo boxes.

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,137
    Location
    Welcome to VBAX Calista.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

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