Haven't tried it on area charts, infact I rarely use them. I always use XYs,
and #N/A are my favourites. Didn't know they don't work with Area charts.
Got to know something new toay. Thanks :)
Mangesh
"Andy Pope" wrote in message
...
Hi Mangesh,
Did you try your suggestion?
The NA() trick does not work for Area charts, it still treats it as zero.
Cheers
Andy
Mangesh Yadav wrote:
For the blank cells, you could enter the formula
=NA()
which will put #N/A in those cells. The cells containing these are not
plotted.
Mangesh
"Tushar Mehta" wrote in
message
om...
The only way that I know how to do this is as follows:
After creating the chart, make sure that the shorter series include
only the cells with data. By default, XL might have included a bunch
of empty cells in those columns. So, if your dept 1 and dept 2 data
are in rows 2 and 3 and big dept in 2:11, make sure that the 1st two
series refer only 2:3.
Now, move the smaller series to the secondary axis. Double-click each,
then from the Axis tab select Secondary.
Format the secondary y-axis so that the scale matches that of the
primary y-axis. Next, hide it (from the Patterns tab set all the
options to None.)
This 'trick' requires that all the series on the secondary axis end at
the same x-value.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I've reading reading posts, and I can't find a specific answer to my
question.
I have some data I want to plot in an area graph.
X-axis values go from 2005 to 2015.
For the first 5 categories I only have values for the 2005/2006 year.
The
next categories I have all data from 2005 to 2015.
When I plot the area chart the first 5 series, with values in 2005 &
2006.
The area graph shows a drop off to zero in 2007.
My question is: Is there a way to not show the drop of from 2006-2007.
I
have no value for that cell, but it still shows a drop off. Is there a
way
to cut off the area at 2006 rather than having the area graph continue
on.
Example:
Department 1: 2005: 10 / 2006: 20
Department 2: 2005: 25 / 2006: 35
Big Department: data for all 10 years.
Hopefully this makes sense. Thanks for your help in advance!
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info