Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Zero values in a chart.
- Thread starter lode
- Start date
henchcliffe
IS-IT--Management
Are you using excel?
If so you can do a find and replace for all zero values.
In the find window click the replace button and in the find field type in 0 (zero) and leave the replace field blank.
If you want to keep the zeros in your datasource you can always copy the column first and then replace the zeros with blanks and chart your new column.
If so you can do a find and replace for all zero values.
In the find window click the replace button and in the find field type in 0 (zero) and leave the replace field blank.
If you want to keep the zeros in your datasource you can always copy the column first and then replace the zeros with blanks and chart your new column.
- Status
Similar threads
- Locked
- Question