| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Charting Slow: | Charts and Charting in Excel | |||
| Excel 2007 and dynamic charting | Charts and Charting in Excel | |||
| excel 2007 Beta-Charting | Charts and Charting in Excel | |||
| Excel 2007 C# Charting problem | Charts and Charting in Excel | |||
| Advanced 3-D Charting - Z axis in back | Charts and Charting in Excel | |||
Linear Mode
