• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

select bar on graph and go to data

If memory serves correctly i believe there was a tutorial on how to create graphs and make them selectable. for example. i have a bar graph that gives me total sales. i can then click on that bar and get detailed info about what info goes to that bar. any suggestions?


Thanks
 
Hmm. Perhaps one of these is what you are looking for?

http://chandoo.org/wp/tag/bar-charts/


Normally if you click on a chart, XL does highlight where the data is coming from as well...not quite sure how much detail you need.
 
yeah, VBA, i have a chart sheet so i can do chart events, I have a list of parts. different people build the parts. I am looking at their time charged to each part. i want to know who charged the less. so when i look at the bar graph of the product, i click on the bar, i can then see who charged to that specific product.
 
Back
Top