Have you ever struggled with editing your ANS document while on the go? Well, DocHub has an excellent solution for that! Access this online editor from any internet-connected device. It allows users to Omit chart in ANS files rapidly and whenever needed.
DocHub will surprise you with what it offers. It has powerful capabilities to make any changes you want to your forms. And its interface is so simple-to-use that the entire process from start to finish will take you only a few clicks.
After you complete adjusting and sharing, you can save your updated ANS file on your device or to the cloud as it is or with an Audit Trail that contains all changes applied. Also, you can save your paperwork in its initial version or turn it into a multi-use template - complete any document management task from anywhere with DocHub. Sign up today!
today im going to show you how to fix this this issue where youve got uh weve got a chart and youve got no values for certain certain months or periods and your chart goes all the way down like this to show that its zeros even though its really just blank and this this shouldnt be populating at all so im gonna start by creating a a new sheet to just show you how this might happen so lets say im gonna type in all the months from january through to december here and what im going to do is enter some sales data here im just going to use some random notes like 500 for january 600 for february 400 for march okay so now if i were to plot this out right now its going to look fine the the one issue thats going to come up however is lets say ive got this data over here and ive got a formula to say okay if this is uh equal to a blank value then its blank otherwise im going to take the value here so if i copy this all the way down youll notice now i run into that issue because