Easy chart question

fidgen

New Member
Joined
Aug 20, 2002
Messages
46
Hiya, I have graphed columns of data that contain numbers intermingled with the #N/A error.

What I'm looking for is to have a line chart that breaks the line where a NA exists and then jumps to the next number rather than joining the line over the "gap" to the next number.

Cheers
Hugh
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

fidgen

New Member
Joined
Aug 20, 2002
Messages
46
also!

is it possible to set the chart to draw a line over 1 NA error but then break if there are 2+ in a row?
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
The only way I know how to do this is to leave the cells blank. Then select the chart and choose Tools, Options and on the Chart tab click Not plotted for empty cells.
 

Forum statistics

Threads
1,144,329
Messages
5,723,734
Members
422,512
Latest member
MHau5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top