+ Reply to Thread
Results 1 to 2 of 2

bar on a column Chart Click Displays another Chart

  1. #1
    Registered User
    Join Date
    12-02-2016
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    21

    Unhappy bar on a column Chart Click Displays another Chart

    Hi need some help about this. I have a column chart and is it possible if I click one of the bars in the chart it displays another chart? and when i click it again it hides the chart. Maybe vba can do this trick? Please help me. Thanks!

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

    Re: bar on a column Chart Click Displays another Chart

    It will require VBA.

    This article should give you all the info you need.
    http://peltiertech.com/chart-events-microsoft-excel/
    Cheers
    Andy
    www.andypope.info

+ 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. Creating a Stacked Column Chart That Displays Monthly Data
    By Bounty Picker in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-22-2017, 08:57 AM
  2. How do I double click a bar in a bar chart and make another bar chart?
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2016, 11:43 AM
  3. Bar chart displays the same number with a gap
    By Linorl in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-26-2015, 04:50 AM
  4. Chart displays same value at different height
    By justinr in forum Excel General
    Replies: 2
    Last Post: 10-08-2015, 01:52 PM
  5. Column chart displays differently even though format is auto
    By brian6464 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-09-2014, 12:06 PM
  6. Replies: 3
    Last Post: 03-23-2011, 09:45 AM
  7. Scatter chart displays as line chart
    By Hannu in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-11-2006, 01:40 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