Chart properties - 2007

[theta]

Hi. I need to know how to 'fill gaps' on chart i.e. produce one continuous line when data points are not present

e.g.

a = 1
b = 2
c = 3
d = 4
e =
f = 6
g = 7

When I plot it, I get a big blank where the 'e' data should be. What property is it that allows to link data points producing a solid line

Need this as I have some missing data but want it to plot the line from point to point

 

[RoryA]

Right-click the chart, choose Select Data, then press the Hidden and Empty cells button, and choose Connect data points with line.

 

[theta]

Legend. Thanks!

They seem to hide all the best bits

 

[RoryA]

The initial Excel 2007 experience is a little like going to the bathroom in the dark while slightly drunk. You know exactly what to do, but it takes longer to find everything and the results can be unpredictable.

 

[theta]

still can't find some things..so installed Ubit

The most common one I use is File > Page setup

This util just places the 'old' menu as another tab on the ribbon

How else would I access page setup?

 

[RoryA]

Page Layout tab, Page Setup group, click the little box in the bottom right corner.