Advanced charting in Excel 2007

X

xexex

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
 
B

Bernard Liengme

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
 
Top