M
Michael van E
Hi I'm using Office 2007. I have two charts using data from the same sheet.
The second graph is a copy of the first. In the first graph, the empty and
zero value cells are not displayed. In the second graph, the zero value cells
is displayed (draged to zero) although the option "connect points with line"
is checked.
The strange thing: if I change the Y-data to another part of the sheet, it
is no longer dragged to zero. Even if the cell is empty it's still dragged to
zero
The second graph is a copy of the first. In the first graph, the empty and
zero value cells are not displayed. In the second graph, the zero value cells
is displayed (draged to zero) although the option "connect points with line"
is checked.
The strange thing: if I change the Y-data to another part of the sheet, it
is no longer dragged to zero. Even if the cell is empty it's still dragged to
zero