Data range blank in Excel (2000)

Topic

New Reply

Can someone tell me how l produce a graph from excel but some for odd reason the space is blank in the data range.
see screenshot.

Reply | Quote

Replies

I’d start by removing the blank rows in between the data.

Reply | Quote

With the blank rows and only a line plotted, there are no lines to plot since none of the points connect. Change to markers and you will see the points.

Steve

Reply | Quote

thanks

Reply | Quote

Another option if you don’t want to remove the blanks:
tools – options – chart(tab)
select “Plot empty cells” as “interpolated”

Steve

Reply | Quote