array chart

I'm trying to have a graph that doesn't chart 0 values. I'm using an array so I can change the value if it equals zero but I don't know what to change it to to make the chart not automatically graph it. Any help is appreciated. This is my code that creates the array, assigns the series to it...

<tbody> Challenge 1: What you know: The employee is in pay grade 3 and rate is $25.30 Challenge: write a formula that looks up the grade, and then returns the value on that range in which $25.30 is nearest to (rounded down) Challenge 2: Write...

Hi I have a Table B3:AD6 on multiple sheets (YYYY-Registration). Cell B1 shows the location of the vehicle. I want to create a table on Sheet (Chart Output) that is the sum of selected tables from other sheets, which sheets are used depends upon the year selected and the Location selected via...

'List of PPT Slides to Paste to MySlideArray = Array(2, 3, 4, 5, 6) 'List of Excel Ranges to Copy from MyRangeArray = Array(Sheet1.Range("A1:C10"), Sheet4.Range("A1:C10"), _ Sheet3.Range("A1:C10"), Sheet2.Range("A1:C10"), Sheet5.Range("A1:C10")) With the above snippet, I need that to...

I spend a good half day trying to work a formula that Sorts a Range in Column A which contains Text and whose values are in B. This should work particularly if there are duplicate values in Column B. I am able to create in a formula in Column B, like this...

Hello, longtime lurker, first-time poster here. I didn't happen to see any topics that directly mentioned this, but I apologize if I missed it. My question is: if I'm populating a chart series with an array formula rather than a range, how do I have missing data points be charted as gaps...

Hi, If this has been answered elsewhere please feel to provide link to the thread. I have been searching for a while but haven't been able to find an appropriate answer. Problem I'm trying to create a line chart using "Scatter with Straight Lines" that will create a gap in the line if Y...