connecting points on a line graph

E

Eitak

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I can't connect my data points on the line graph.I know how to do this on Microsoft Excel 2007 for Windows. You open the data source box by right clicking on the graph area, then you select the button "Hidden and empty cell settings", choose "show empty cells as" and select "connect data point with line". However the "Hidden and empty cells settings" box is missing on the Office for MAC 2008 version of excel. Does anyone know how I can get these data points connected? There are empty cells between the cells with data in them which is why they are not automatically connected. This is necessary for the type of experimental data that I am attempting to graph so I can't change that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top