Does anyone know if Excel can display the sample group population within the
chart i.e. N=100, (if 100 people answered the question) obviously this can be
done manually but it would be cool if excel could do it itself.
The reason I want to do this is so the reader of the graph can ...

I have three charts, each of which shows a normal curve (bell shaped) with 3
different means and 3 different standard deviations.  Taken individually, the
3 charts are a "masterpiece."
However, I wish to merge the three charts into one so I can show the 3 bell

Whenever I enter a zip code or birthdate (01/02 1943) begining with a zero in
Excell, the zero is dropped when I print a list.  How can I ge the zero to
display at the beginning in these instances.
David (a dunce, I guess)

I have 3 data ranges on a line chart and want to show what the different
acceptance bands (terminology ?? = 'data should be within') for each series.
Any suggestions?

How do I surpress the numbers from showing on a pie chart and just show labels?

I have given the below formula and this gives #NA in columns with no
values. I want to change the font colour to white if the cell has #NA.
=IF(ISERROR(100*(AF5-AH5)/AH5),NA(),100*(AF5-AH5)/AH5)

I am using XY (Scatter) type chart to show the blood pressure verse age of
130 people. Untill here there is no problem and I chart shows neatly.
Some of these people are male and others are female. I want to separate the
gender by color or marker in the chart, so in one glance I ...

i am currently trying to create a line chart using data found in different
worksheets, but in the same workbook. although i can carry this out by
cutting and pasting all the required data into the same worksheet whenever i
try to pick the data from several or even two sheets i ...

David and Andy,
Thanks for your posts. Whether I use #N/A or =NA() I get the value 0 on my
chart and it is plotted so it looks like the value has gone down to zero. I
do not even want the line after November since we have not yet closed 12/2007.

for a High School science project my daughter created a survey with 39
possible responses  (3 groups of 13 responses in each group) the people
taking the survey are supposed to pick the top 4 responses in each group
(numbered 1-4, 1 being the highest).  Other information is Age, ...

Professionals, I am trying to create a goal line on a chart which contains
data from the past however I need the line just going forward. I can create a
series 2 goal line but I cannot figure out how to make the goal line start
mid stream of the data I currently have.

I used to use excel for matching graph data by dragging the data point to a
point on an existing line.  Is this feature is no longer supported in 2007?  
Is there a workaround or do i have to manually change the numbers?

Hello professionals, I would appreciate some help on this problem. Im a
pretty good basic user of excel and generally dont need anything complex, but
I cant figure out if I can do what I want with the information I want.
I use Excel for my jobs to generate reports, submittals, etc ...

I have an excel spreadsheet with addresses sorted by zip codes. I am trying
to creat a pie chart indicating what % of our referrals come from what zip
code. How do I get the repetitive zip codes to total? Right now every line is
creating a separate piece of the pie.

Professionals, I want to continue my 2007 charts through 2008 but without
values until the time arrives. My charts just show 0's for all of 2008 even
though I clicked on tools, options, chart, and plot emty cells as not plotted
(leave gaps).