HI,
I am using Excel 2016 and need a solution of my problem.
Problem :
I want to show Zero drop as gap in line chart (same as showing in attached sample sheet). My Data is coming through formula in Row no 4 and where No data found it shows Zero value (highlighted with Yellow color) and than according to that data, chart -1 is generated but I don't want to show chart line as continues , i have to show the zero value as gap (Chart-2).
Please suggest.
Thanks
Nitesh
In B5, use (dragged across)and chart thatFormula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
HI Thanks for the reply. I have pasted the formula and created a chart but in chart gap is not visible as per chart2 in my attached sample sheet.
I can't look at it for a while. I'll follow up if no-one else steps in in the meantime.
Povide a workbook showing what you've tried.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I would have thought you could use a formula. For example, if the value depended on J2, use:Sadly, that doesn't seem to work. It's as though a formula that returns a null value isn't treated the same as an empty cell.Formula:Please Login or Register to view this content.
Hi Ali,
Sample sheet attached. I want chart1 to be same as Chart2 but in chart1 value populated through formula.
HI TMS,
Formula is not a problem, my problem is that, I want chart1 to be same as Chart2 but in chart1 value populated through formula not manual.
Someone else might be able to correct me... but I >>think<< Excel cannnot do that, unless you subdivide the data into separate datasets.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
See file attached
It is working fine when we manually entered the value but not working when value populated through some formulas
If memory serves, 2016 should skip #N/A values (unless you have set it to interpolate); 365 has a specific option to treat #N/A as blank.
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks