+ Reply to Thread
Results 1 to 2 of 2

Toggle between different cuts of the same data set on a bar chart

  1. #1
    Registered User
    Join Date
    08-12-2020
    Location
    London, England
    MS-Off Ver
    MS 365, v1902
    Posts
    1

    Toggle between different cuts of the same data set on a bar chart

    Hello,

    Is there are way for me to toggle (through the use of a drop-down menu, for example) between different cuts of the same data set on a bar chart?

    For example, in the worksheet attached - is there a way to toggle between Industry, Region and Subspace depending on how I want to see the split of the P&L?



    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Toggle between different cuts of the same data set on a bar chart

    You could do something like the attached. You need to refresh the pivot table after changing the dropdown in I1 (though that could be automated).
    Attached Files Attached Files
    Rory

+ 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. [SOLVED] toggle data series on/off on chart
    By xelhelp in forum Excel General
    Replies: 5
    Last Post: 12-08-2021, 04:23 AM
  2. Toggle Between Data Sets in Excel Chart
    By Bazzer79 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-19-2020, 04:24 AM
  3. toggle between chart selected point and data cell
    By royazriel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-18-2015, 02:09 AM
  4. [SOLVED] Radio Buttons to Toggle Chart Source Data
    By gophins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2015, 11:39 AM
  5. Toggle chart on and off or to different chart types?
    By dsciola in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-22-2014, 02:50 PM
  6. Chart cuts first and last bar
    By a94andwi in forum Excel General
    Replies: 0
    Last Post: 08-21-2012, 07:32 AM
  7. [SOLVED] Toggle Buttons to change data source in single chart
    By eface2face in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2012, 03:45 PM

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