Display empty cells as gaps, zero, or connect in chart

[kerrie_lorena]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I recently switched from a PC to a mac. I want the chart to not leave gaps where there are blank cells in a series. On my PC, in the select data dialog box I could click on the "hidden and empty cells" button and choose to display empty cells as gaps, zeros, or connect data points with a line. On my mac, empty cells are displayed as gaps in the chart (xy scatter with line), but I want to connect the gaps and cannot figure out how to do that.

thanks in advance
kerrie

 

[John McGhie]

Go to Excel>Preferences>Charts and turn on or off the options you want.

Then go to Help>Send Feedback and give them a good kicking for not putting
that in the help.

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I recently
switched from a PC to a mac. I want the chart to not leave gaps where there
are blank cells in a series. On my PC, in the select data dialog box I could
click on the "hidden and empty cells" button and choose to display empty cells
as gaps, zeros, or connect data points with a line. On my mac, empty cells
are displayed as gaps in the chart (xy scatter with line), but I want to
connect the gaps and cannot figure out how to do that.

thanks in advance
kerrie

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]