If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
NA() is the usual workaround for this is, and it works great for line or
XY charts, but it will not work with an area chart as Lasci was using. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Flávio, SP, Brazil wrote: Hi, Lasci, I´ve just done another workaround that was use na() function instead and it did pretty well in my particular case. But, thanks a lot anyway. Best wishes, Flávio. "Lasci" wrote: Hi, The only work around I have found is to interpolate the missing values in the spreadsheet myself (which is what excel does for the line chart) by using some kind of average. Not ideal but gets around the problem relatively quickly.... "Flávio, SP, Brazil" wrote: Hi, Lasci, I have the same difficulty. Couldn´t anyone find a solution for Lasci´s problem yet? Thanks, Flávio "Lasci" wrote: In the line graphs, I have managed to make excel ignore the missing values, but only by having another data set that has all the values in the graph, and then blanking out this line by changing the colour. This is the only work around I seem to have found so far..... "Jon Peltier" wrote: Unfortunately this trick is ineffective in an area chart. You can only make it work with real blank cells. If you have some kind of lookup formula, you'll have to delete the ones that have no returned data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Pierre wrote: Cannot you put #N/A in the cells containing 0 ?? I think it does not read these values |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart object missing data randomly when running large report | BarryL | Setting Up & Running Reports | 0 | September 30th, 2005 04:11 PM |
How to omit data in a chart when there are error values? | Bou | Charts and Charting | 2 | June 10th, 2005 08:51 PM |
Interpolating or estimating missing data values in a series for a | John | Setting Up & Running Reports | 0 | November 4th, 2004 01:55 PM |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
Dynamic Offsetting, Names, Arrays, Range, Chart Values. NEED HELP | Bob Lidgard | Charts and Charting | 14 | February 25th, 2004 03:26 PM |