Advanced charting in Excel 2007

  • Thread starter Thread starter xexex
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic Sorting? 6
create blank/empty cell - don't want a zero to be plotted in chart 6
PowerPoint Embed scroll excel chart and data in powerpoint 0
Chart and date data 2
Excel 2007 Creating a chart 1
Remove Space on Bar Charts for Missing Data 2
How do I hide gaps in an Excel 2007 chart? 2
What my chart to exclude 0 data... 0

Back
Top