Ignore N/A values with an area chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that excel will ignore a value of #N/A on a line chart, but with an
area chart, the result plots a value of zero, making the area look like a
bunch of spikes. Is there a way to ignore that value and essentially connect
the two available points to give the chart a continuous area?
 
What you can do is interpolate between the adjacent values. There is no
value that will make an area chart not dive to zero.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top