troubleshooting Question

Bar Chart (Urgent!)

Avatar of Victor Li
Victor Li asked on
VBAMicrosoft ExcelMicrosoft Office
5 Comments1 Solution106 ViewsLast Modified:
Hi everyone, so I have a bar chart that is date (x-axis) by hours (y-axis), and for each date there are two bars (based on data from Column C and Column D). So I want to make it so that the chart automatically updates everytime I enter a new set of data for column C and D, and everytime the new set of bars appear in the chart they have values on top of them. So if I have 5 set of data (C1:C5, and D1:D5), only C5 and D5 bars have values on them. And if there is C6 and D6 then the values on C5 and D5 bars will disappear and instead the C6 and D6 bars will have values on them in the chart. Finally if the value for any bar is 0, then no value will be shown on that bar. Any insight on how to make macro for this? Thanks a ton!
Dustin Saunders
Co-Founder and Chief Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2016

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros