« Difference Between - "Forecast" & "Trend" | VLOOKUP 2nd Version (Advanced) » |
Feb
16
DIMPLE on My Chart
chartsHi there,
Do you like dimple?
Of-course, I like dimple on heroine's cheek.
Do You?
Of-course, you are. I know you like on heroine's cheek but I am asking in excel chart.
Fine, I will explain the problem and the solution about dimple chart using 4 pics. These four pics will conclude the post of today.
...
Alright?
Go...!
1. Data Table to prepare a chart:
2. Chart Which Looks for the above Data Table:
3. Data Table After Changing the 0 (zero's) to =NA():
4. Chart After Changing Zero's to =NA():
That's it. Magic Works!!!
Note: If you find challenging to understand, please leave a comment here.
DID YOU FACE DIMPLE CHARTS?
Please share us how you come across such scenarios in the charts using below comments section.
If you find this useful, please do share it on your social networking sites by clicking on the icons placed around the blog.
If you want to receive such emails to your mail box REGISTER here for free.
SOME IMPORTANT LINKS:
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments