A
Aurora
I am using Excell 2000
I feel like a dummy. While I use Excell on a regular
basis, about 1 a month, I have not created a chart (graph)
in Excell in years. Now I am trying to create a scatter
graph of which I have never done. This is for our salary
budget. I have been asked to show how many people are in
each salary range percentile by wages. Example Emp #1,
making $25000 may be in the 70% range for a specific
classification, while emp #2, making $25000 is in the 80%
range for his classification.
I began by making a chart with the salary range
percentiles in each column Ex: 70%, 80% 90% up to 120%.
Now in each column I put the each employee's wages$$
amount in the column that it falls in. The 70% column may
only have 2 emp that fall in that area while the 90%
column may have 5-6 people etc.
My graph has the 70-120 percentile ranges as the "x'
axis. The graph show wages from $25,000 through &100,000
in increments of $10,000 on the "Y" axis. But I can't
seem to get the scatter points on the graph. On the side
is a legend that shows the various $$ amounts by series.
One set begins with a blue diamond, the next set begins
with a red square etc. But they don's seem to correspond
with my chart; and each series picks up part if not all of
the information from the previous series, so that I end up
with a legend that has over twice the number of entries I
have.
Can anyone point me to an article or instructions on "how
to create a scatter graph"? Please Help.
Aurora
I feel like a dummy. While I use Excell on a regular
basis, about 1 a month, I have not created a chart (graph)
in Excell in years. Now I am trying to create a scatter
graph of which I have never done. This is for our salary
budget. I have been asked to show how many people are in
each salary range percentile by wages. Example Emp #1,
making $25000 may be in the 70% range for a specific
classification, while emp #2, making $25000 is in the 80%
range for his classification.
I began by making a chart with the salary range
percentiles in each column Ex: 70%, 80% 90% up to 120%.
Now in each column I put the each employee's wages$$
amount in the column that it falls in. The 70% column may
only have 2 emp that fall in that area while the 90%
column may have 5-6 people etc.
My graph has the 70-120 percentile ranges as the "x'
axis. The graph show wages from $25,000 through &100,000
in increments of $10,000 on the "Y" axis. But I can't
seem to get the scatter points on the graph. On the side
is a legend that shows the various $$ amounts by series.
One set begins with a blue diamond, the next set begins
with a red square etc. But they don's seem to correspond
with my chart; and each series picks up part if not all of
the information from the previous series, so that I end up
with a legend that has over twice the number of entries I
have.
Can anyone point me to an article or instructions on "how
to create a scatter graph"? Please Help.
Aurora