+ Reply to Thread
Results 1 to 3 of 3

Using a slicer on a table for use in a bubble graph by date

  1. #1
    Registered User
    Join Date
    01-06-2022
    Location
    US
    MS-Off Ver
    MS Office 365
    Posts
    7

    Using a slicer on a table for use in a bubble graph by date

    I'm attempting to use a slicer on a single table row. I then want each column of that slice to be included in a vlookup formula that is associated with a plot graph containing x and y coordinates and the volumes of the bubble chart represented by the vlookup results. The idea is that the locations on the map do not move, but the volume of each bubble changes as you select the date.

    I want to be able to add dates to the table for as long as the project persists so keeping this as simple as possible is key. Is there an elegant way to achieve this without changing the structure of the data?

    Dummy file attached with my current setup and thank you in advance.

    TestExcel.xlsx

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

    Re: Using a slicer on a table for use in a bubble graph by date

    You can use the SUBTOTAL function with the codes that exclude hidden values.

    I have also added the picture to be the fill of the plot area and the chart title is linked to the Room name.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-06-2022
    Location
    US
    MS-Off Ver
    MS Office 365
    Posts
    7

    Re: Using a slicer on a table for use in a bubble graph by date

    Well that is just too easy. Thank you so much, works great!

+ 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. Excel table with slicer but want to disable only 1 slicer from a chart
    By tml2424 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-02-2023, 07:06 AM
  2. Slicer for table with date column showing wrong result
    By p3rlend in forum Excel General
    Replies: 1
    Last Post: 04-24-2016, 06:37 AM
  3. Pulling the start and end date from a pivot table slicer
    By rwiper11 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-27-2015, 08:51 AM
  4. Bubble graph
    By Jan Rennel in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-10-2014, 12:12 PM
  5. Replies: 0
    Last Post: 04-04-2013, 02:30 AM
  6. Bubble graph help
    By Ghost World in forum Excel General
    Replies: 1
    Last Post: 02-03-2011, 10:02 AM
  7. [SOLVED] How do I link a bubble in the bubble graph to another chart?
    By Pradnya Purandare in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-17-2006, 12:25 AM

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