adambgoldstein
New Member
- Joined
- Jun 30, 2017
- Messages
- 5
I am trying to create a line graph based on the months of the year and a percentage. The percentage is based off of a formula, so if the numbers that are part of the percentage are zero and zero (because the month hasn't happened yet) it comes up as "#DIV/0!". When I graph this information, any cell that is "#DIV/0" comes up as zero instead of not graphing at all. I have tried adding in a qualifier to make the cell " " when it divides zero by zero, but that still shows up as zero in the graph even though the cell shows up as a blank. Below is the data set I am working with. Once it gets to Jun, the line graph shows zero through Dec. Is there a way to have the graph not plot for non numbers? Thank you!
<colgroup><col><col></colgroup><tbody>
</tbody>
Month | Percent |
Jan | 100% |
Feb | 50% |
Mar | 25% |
Apr | 100% |
May | 60% |
Jun | #DIV/0! |
Jul | #DIV/0! |
Aug | #DIV/0! |
Sep | #DIV/0! |
Oct | #DIV/0! |
Nov | #DIV/0! |
Dec | #DIV/0! |
<colgroup><col><col></colgroup><tbody>
</tbody>