We help IT Professionals succeed at work.
Get Started

Preventing Null values from plotting in Excel Charts.

fb1990
fb1990 asked
on
140 Views
Last Modified: 2016-08-18
Hello EE,

I am working on creating a report on data that is constantly changing.  I want to plot the only cells with records.  In the attached spreadsheet, if i click on column B7 to show Group 1, there are 21 records that needs to be plotted.  If i click on B7 to select Group 2 there are 6 records to be plotted.  For group 2, I want to delete or hide cells that are not populated and only plot the cells that are populated with data.  I am thinking this can be accomplished using vba.  My goal is to create 2 separate reports for Group 1 and Group 2

Thanks in advance for your assistance
My-Sample.xlsx
Comment
Watch Question
Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE