Excel Charts 2

[RedMoo]

Hi,
I am doing a line graph in Excel and in the data that I am using there are some blank fields. This appears as breaks in the graph.
Is there anyway of editing the graph so that it will show only a continuous line and not take the blank fields into account.

Cheers

 

[sawedoff]

You can choose another variety of the line chart (middle one on the top row for example) but then you have the problem that the line plummets to zero for the skipped data value.

Sawedoff

 

[SkipVought]

ALSO...

if you have your OPTIONS set to plot only VISIBLE cells, you could AutoFilter to display ONLY data with values.

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]

 

[sawedoff]

Or you could check "Show values as interpolated in the Tools-Options-Chart settings.

Sawedoff

 

[RedMoo]

Cheers Sawedoff.......showing the values as interpolated does exactly what im after

 

[sawedoff]

Thanks. Glad it helped. And a shiny thing to Skip, too, for pointing me in the right direction to find it.

Sawedoff