D
Dora Smith
I created a custom line chart with lines on 2 axes. It was supposed to
show date by months in the x axis, number of records in the first y axis,
and percentage of records in the second y axis. It does show the x and y
axes correctly.
I selected month, and then the three adjacent columns of data to plot in
three separate lines on this plot; number of acceptable records, % of
acceptable records to total, and % of acceptable records to valid.
My legend shows number of acceptable records, % of acceptable records to
total, and % of acceptable records to valid.
The chart graphed all acceptable records and % of acceptable records to
valid (the first and third of the three adjacent columns I selected
together) correctly, but graphed % of acceptable records to total (the
second of the three adjacent columns selected together) as a flat line with
y value of 0.
I actually made two of this graph; one for fiscal year 2004, and the other
for fiscal year 2005, with identical results.
My boss suggested that maybe the names are two similar and had me change
one, and this changed nothing.
% acceptable records to total ranges from 20 to 32 percent, and % of
acceptable records to valid records ranges from 19 to 39 percent, and when
these two are graphed together on a line graph, they show jagged lines that
for the most part run parallel to each other. The data itself does not
present a logical reason why one column of data should flatline at zero on
the graph.
What is the reason why only two of the lines graph correctly on the custom
line chart with two axes? Is it supposed to display correctly only two
lines? And why did it pick the first and third column of data instead of
the first and second line of data to display correctly?
Is tehre a way to get all three columns of data to graph correctly?
show date by months in the x axis, number of records in the first y axis,
and percentage of records in the second y axis. It does show the x and y
axes correctly.
I selected month, and then the three adjacent columns of data to plot in
three separate lines on this plot; number of acceptable records, % of
acceptable records to total, and % of acceptable records to valid.
My legend shows number of acceptable records, % of acceptable records to
total, and % of acceptable records to valid.
The chart graphed all acceptable records and % of acceptable records to
valid (the first and third of the three adjacent columns I selected
together) correctly, but graphed % of acceptable records to total (the
second of the three adjacent columns selected together) as a flat line with
y value of 0.
I actually made two of this graph; one for fiscal year 2004, and the other
for fiscal year 2005, with identical results.
My boss suggested that maybe the names are two similar and had me change
one, and this changed nothing.
% acceptable records to total ranges from 20 to 32 percent, and % of
acceptable records to valid records ranges from 19 to 39 percent, and when
these two are graphed together on a line graph, they show jagged lines that
for the most part run parallel to each other. The data itself does not
present a logical reason why one column of data should flatline at zero on
the graph.
What is the reason why only two of the lines graph correctly on the custom
line chart with two axes? Is it supposed to display correctly only two
lines? And why did it pick the first and third column of data instead of
the first and second line of data to display correctly?
Is tehre a way to get all three columns of data to graph correctly?