Advanced charting in Excel 2007
 

Hi,

I have a colum of data that has gaps in it, and where the data items
are constantly changing.

Does anyone know of a way to have a chart that ignores the gaps, and
which orders the data items largest to smallest?

Many thanks

Advanced charting in Excel 2007
 

In the gaps enter =NA(); this shows as #N/A and is ignored by the chart
engine

Sort tithe data using Data | Sort; maybe record a macro to make this
automatic.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"xexex" wrote in message
oups.com...
Hi,

I have a colum of data that has gaps in it, and where the data items
are constantly changing.

Does anyone know of a way to have a chart that ignores the gaps, and
which orders the data items largest to smallest?

Many thanks