Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts that ignore certain data
I have a chart that takes data from a list. Some of the data fields have #NA.
How do I get i to ignore those details so it only plots based upon the true figures Abbey 0 First National1 RBS 1 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts that ignore certain data
Generate dynamic names to reference the data ranges used by the charts. If
you've got this data in columns A and B, you could define these names (Insert menu Names Define) Name: MyVals RefersTo: =OFFSET($B$1,0,0,COUNT($B$1:$B$65536),1) Name: MyCats RefersTo: =OFFSET(MyVals,0,-1) Use these names as the source data of the chart series. Go to Chart menu Source Data Series, select the appropriate series, for X Values (or Category Labels) enter =Sheet1!MyCats (or if there's a space in the sheet name, ='Sheet 1'!MyCats), and for Y Values, enter =Sheet1!MyVals (or ='Sheet 1'!MyVals). For more information and examples: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mark R" wrote in message ... I have a chart that takes data from a list. Some of the data fields have #NA. How do I get i to ignore those details so it only plots based upon the true figures Abbey 0 First National1 RBS 1 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATA Validation (Ignore Blanks) | Excel Discussion (Misc queries) | |||
Ignore Data for Dynamic Range | Excel Worksheet Functions | |||
How do I get charts to ignore results of a formula if it equals 0 | Charts and Charting in Excel | |||
Get a pivot table to ignore data | Excel Discussion (Misc queries) | |||
Data Validation - ignore blanks | Excel Discussion (Misc queries) |